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.