Filters that only alter a table visually

Question

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.

Answer

You may be able to create a custom filter and use the "contains" option. Depending on how your dates are setup, may allow you to use something like 202307. 
Without knowing how the data is structured for date, may be hard to give a specific answer.

Filters that only alter a table visually

Relevant content