Always show data 10 days

[kitti]

Hi experts,

I have a date table and my another data table. How do I show data for 10 days excluding holidays? For instance, the report displays data on day 9-19 because day 10 and 11 are holidays.

Many thanks,

KL

[Tanushree_Kapse · Accepted solution]

Hi @kitti ,
Create another column where you display the dates for which you are having data in the table.
Dates_new= IF(column_name= BLANK(), BLANK(), Dates)
Then use this Dates_new column to get the Top 10 Days. 
You can use the Top N filter on the visual.