CALCULATIONS IN TABLE CELLS IN SAP ANAYTICS CLOUD

[former_member609155]

I AM TRYING TO CREATE A CALCULATED ROW OF THE DIFFERENCE OF TWO VERSIONS. THE PROBLEM IS THAT WHEN I DO IT, IT DOES NOT SHOW THE CALCULATION AT THE PRODUCT DIMENSION LEVEL.

HELP ME PLEASE.

[former_member609155]

Thank you very much for you help, but what i want to achieve is make it ook this.

That way i could visualize it in a demo of sap analytics loud.

[DebjitSingha]

Sorry, I didnt got your last reply.
Are you saying that you, no longer need comparison between versions? instead want to compare products?

may be an example of what you have vs what you want to get would help...

[former_member609155]

I am trying to replicate a demo of SAC, I have mu model with two versions (FCST_1910 and RGP)

I want to get to have a comparison of versions in the following way.

Demo photography

[DebjitSingha · Accepted solution]

Hello jkevin913,

As mentioned earlier, you can use "Cross Calculation" for your setup. In-fact cross calculations are built for such requirements 🙂 Here is an example similar to yours. Adding Forecast and Actuals by Product Type.

This is how the final output would look like.

Steps1-

1. Add cross Calculation under rows.

   

2. Locate under rows > Cross Calculation > More> Add Calculation > Restricted Measure for Actuals

   

3. Create restricted measure for Forecast as well:
   
4. Add another calculation under cross calculation. This time it should be Calculated Measure type. Like below-
   

   

5. Now remove Account dimension from rows and leave Cross Calculation.
6. You can change the order of individual Cross Dimensions –

   

7. Now that restricted measure are appearing under calculation you can calculate % contribution and other similar variance.

Hope this helps. Let us know if you have any query around this topic.

Viewers/ readers - If you find above information helpful, feel free to up-vote (arrows on left side).

- Debjit

[former_member609155 · Accepted solution]

Thanks so much !!