I have the Plan Amounts distributed across Fiscal Year Periods for various WBS Elements in the cube.
I have to give a report wherein I should display the Total Plan amount for each of the WBS Element in one column, and the plan amounts across the fiscal year periods in the corresponding columns.
The user enters a Plan Start Date and a Plan End Date as input. The fiscal year periods to be displayed should be between this selection. For example if the user enters Plan Start Date as March07 and Plan End Date as Jun 07, the data should be displayed as follows:
WBS Element Total Plan Mar07 Apr07 May07 Jun07
WBS1 5000 3000 1000 0 1000
WBS2 8000 0 2000 4000 2000
If I take WBS Element in the row, Amount and Fiscal Year Period in the column, I am getting Plan Amounts distributed across the Fiscal Year Periods. I am not able to display the Total Plan amount.
If I take WBS Element in the row, and Amount in the column, I am getting Total Plan Amounts for each WBS but I am not getting amounts distributed across the Fiscal Year Periods.
I have tried by creating restricted key figures for all the fiscal year periods, but this doesn't work as the Fiscal Year Periods to be displayed are dynamic based on the user selection of Plan Start Date and Plan End Date .
Is there any way this can be handled by writing some ABAP code??
Please suggest on what can be done.