Skip to Content
0
Former Member
May 08, 2013 at 07:01 PM

Key Figure pattern Generation in report

24 Views

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)