Multiply many values in the same cell with different data source

[former_member414265]

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,

[former_member186338]

Sorry, but absolutely unclear!

Please provide a screenshot!

Vadim

[former_member414265]

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.

[former_member186338]

Sorry, but what is behind the idea to describe Excel table in words instead of meaningful screenshots?

[Former Member]

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