I have expression to pick the expression from Current QTR...so when current qtr starts it will show that particular expense.
Is there anyway to show Current QTR expense after 29 days ,once the current Qtr starts...for ex:
3 rd qtr start from 7-01-2017.But want to show 2 qtr data until 7-20-2017 and data should switch to rd QTR from 7-21-2017.
My data is in the below format.
ID Q1-2017 Q2 - 2017 Q3 - 2017 Q4-2017 Q1-2018 Q2-2018 Q3-2018 Q4-2018
1 10000 20000 30000 20000 20000 10000 50000 50000
2 20000 20000 30000 20000 30000 10000 50000 50000
3 20000 20000 30000 20000 30000 40000 50000 50000
Here until 7-29 I want to show Q2 - 2017 and from 7-29-2017 I want to show Q3 - 2017 data..
Thank you very much