on 06-27-2015 2:56 PM
Dear SAP BPC experts,
I have two dimensions in the row axis static report:
Account 1000
Data source Manual input
I have one dimension in the column axis:
Time 201501
The combinations of the row axis (account, data source) and the column axis (time) define the value in the excel cell B10 which is 10.
Account data source time value
1000 Manual 201501 10
I have to multiply the value of 10 in the cell B10 with the account 1000 but with the correction data source:
Account data source time value
1000 Correction 201501 1.5
The calculated value should be in the same cell B10 = 10*1.5=15
Is there a way to do this multiplication in the same cell B10 where the row axis contains the account 1000 with the data source manual or any additional data row should be defined with the account 1000 and the data source correction that I get the value of 1.5 for the multiplication?
Thanks,
Sorry, but absolutely unclear!
Please provide a screenshot!
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Vadim, Thanks for your answer.
Since then I have realised that another row has to be inserted to the row axis and based on this the input ready layout will work.
One row contains the values with the data source correction and the other role is calculating the value by excel formula for the data source manual input.
Hi Tamas,
Instead of displaying in the same cell, you can have two different columns for value (say column B and column C which has the formula)
When the Datasource is 'manual' , the column B needs to be displayed and column C is hidden and when the datasource of 'correction' , B is hidden and C is displayed.
The hide/unhide feature can be managed via simple VB macro code.
Regards,
Varsha
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.