Hi Experts,
I am looking for generating following pattern for a report:
Fiscal Qtr | Sales Region | Sales | Profit | %
Q1/2012 | S101 | 50000 | 5000 | 10
Q1/2012 | S102 | 70000 | 3500 | 5
Q1/2012 | S103 | 60000 | 12000 | 20
Q1/2013 | S101 | 50000 | 2500 | 5
Q1/2013 | S102 | 50000 | 5000 | 10
Q1/2013 | S103 | 60000 | 3000 | 5
So the idea is once a user enters a Qtr value in selection screen, it generates result for the selected Qtr and also for the next year Qtr.(Ex. Q1/2012 will also display output for Q1/2013)