Skip to Content
0
Former Member
Dec 06, 2011 at 09:45 PM

Drill down on Fiscal year period shows results in 2 rows

58 Views

Hello All,

My report has a requirement to analyze the data across different fiscal year. When the report is then drill downed on Fiscal year period the data is shown on 2 lines.

eg.

report run for 2010 and 2011 for material M1 and plant P1

data in out put:

1) No Drill Down

Material Plant 2010Price 2010Volume 2011Price 2011Volume

M1 P1 100 1000 110 1100

2) Drill down on fiscal year period it shows data as :

Material Plant Fiscal-Year-period 2010Price 2010Volume 2011Price 2011Volume

M1 P1 01.2010 100 1000

M1 P1 01.2011 110 1100

3) How the data is needed:

Material Plant Fiscal-Year-Period 2010Price 2010Volume 2011Price 2011Volume

M1 P1 01 100 1000 110 1100

Any simple way to do this? i can not add the navigational attribute to 0FISCPER as i do not have the time to modify the standard object and get all the approvals.

Regards,

Vijay.