Filters that only alter a table visually


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.

asked a year ago223 views
1 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.

answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions