Skip to Content

Hierarchy difference total on story tables

Hello everyone.

I have a question about a SAP Analytics Cloud functionality.

Is it possible change the hierarchy functionality to make a difference between the measures associated to a dimension?

I'm going to attach a screen.

Thanks for all the suggestions.

Regards.

2018-02-26-144239.png

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 28 at 09:42 PM

    Hey,

    Sorry, I forgot about that question. If you filter and only show the members (years) that you want, you will remove that (all) hierarchy element (top-level on date hierarchy).

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 26 at 09:50 PM

    Hi Juan Elías Rivero Domínguez ,

    Not sure if I understood correctly the question. If you want to have a calculated measure so you can compare your sales from 2017 to your sales from 2018, you can create restricted measures to filter by year:

    https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/df0e123a79624e68a0735b557ef52081.html

    You will be able to create a simple calculation using these restricted measures.

    Cheers,

    Julian

    Add comment
    10|10000 characters needed characters exceeded