SAP Analytics Cloud Planning - Difference between Category Members

[guenay]

Hi Friends,

I want to show the difference between Category members.

Let's say I have actual values and plan values. My measure is turnover.

The problem is now: I can't execute a calculation on different Category members. I can either calculate actual with another actual value or planning with another planning value.

How can I compare actual with planning? Does someone has an idea?

Kind regards,

Ismail

[DebjitSingha · Accepted solution]

Hello guenay,

You can use "Cross Calculation" along with "Restricted Measures" 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, difference 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

[guenay · Accepted solution]

Hi Debjit,

thank you for your super quick response. It's crazy, your are always answering my questions! I think I owe you at least a lunch! 😉

Now to the results:

My initial set up was the same as yours! BUT my mayor mistake was that I had "Category" listed in my table. The calculation will always be shown separated as long as I have "Category" selected as Coloum or Row. Long Story short: Now I have my desired result!

Thanks again!!!

Best regards,

Ismail