Hello, I have a table with a lot of daily sales in QuickSight. I have grouped the table by daily date and created two more columns: daily sales for this year using the formula = sum(ifelse(date = date, sales, 0), and last years sales using the formula = periodOverPeriodLastValue(sum(sales),fecha, WEEK, 52).
However, I want this table to visually display only the information from this month, but when I add a filter to the date column, my column from last years sales turns blank because there is no information on earlier sales. Is there a way to visually filter a table without modifying the data?
Thanks in advance.