I have a requirement to show last 5 Quarters(Column names should be dynamic when we move to next Quarter),QoQ%(Percentage Diff between Q1,Q2),YoY%(Percentage Diff between Q1 & Q1 of last Year) ..
Can anyone help me how to achieve this?
P.S,Wedo not want QoQ% and YoY% spilt by all the 5 Quarters again.
Can you provide a sample data? basically, you need join/union your data to itself for twice to get the QoQ % and YoY %.