i am looking for something different. by default.. for quarter i need to show only Q2 vs Q1, if i am in Q2 and Q3 vs Q2 if i am in Q3.
for year i need to show only Q4 2017 vs Q4 2018, Q3 2017 vs Q3 2018 by default.
can you please help me achieve this.
Make a calculated field: Quarter Show and put it in filter:
DATEPART('quarter',today())=DATEPART('quarter',[Order Date]) OR
Since now is March (Q1), I let it show Q1 and Q4. If now is April-June, it will show Q2 and Q1, If July-Sept, will show Q3 and Q2. If Oct-Dec, show Q4 and Q3.
For the YoY, I use 2015 and 2016 (we don't have year 2017 and 2018 in superstore sample data), and show Q3 and Q4 only according to your requirement.
QoQ2.twbx 1.2 MB
Thank you Michael Ye. This works.. but for Quarter on Quatrer.. i need to show only two quarters.(Q3 vs Q2). and year on year.. only two quarters(Q1fy17 vs Q1fy18) by default.. can you please let me know how to achieve this.