Hi, I have a dashboard contains two sheets. Sheet1 is summary by Month and Sheet2 shows the details of the month you select in Sheet1.
As Sheet2 contains calculations based on full dataset, I cannot add action as filter. Is there are any way when I select the Month and hide others other than filter?
Thanks,
Ying
12 answers