Thank you Sankar,
I also want to exclude holidays. which are specific for my business.
how can i do that?
for example, my Business Holidays are
Jan 1st, Dec 25th,
Nov 26th, july 4th. etc.....
To exclude holidays
1. Right click on date dimension and create a group by selecting holiday days - name it 'holidays' and ignore the rest
2. Drag the newly created group field into filter and exclude 'holidays'
Thank you for replying,
The date field which i can group have only historical dates, But i would like to exclude regular holidays for future dates like in 2017 and so on.
1 of 1 people found this helpful
To hide future dates or dates in data:
IF [DATE] = #2017-1-1# then 'hide'
ELSEIF [DATE] = #2017-12-25# then 'hide'
Date Format is #Year-Month-Day#
You can add more dates using multiple ELSEIF
Drag this calculation to filter and select show