Skip to main content
Solved

I want the general total number of items as the output over all rows in an OLAP. Is there a possibility to have it dynamic and not just type in a fixed number like e.g., '123456'?

  • April 17, 2023
  • 2 replies
  • 9 views
M
Level 2

For example to calculate the share of items for each region. If I have an OLAP with all regions, I need to have the total number of items divided by the items for the region, but I want to have the total number dynamic to not update the total number manually.

So the same output over all rows. Does someone knows how to do it?

Best answer by guillermo.gost12

I think what you need is the KPI NOT grouped by the dimensions. You can try with GLOBAL(KPI)

 

HTH

    2 replies

    G
    Level 12
    • guillermo.gost12
    • Level 12
    • 471 replies
    • Answer
    • April 17, 2023

    I think what you need is the KPI NOT grouped by the dimensions. You can try with GLOBAL(KPI)

     

    HTH

    M
    Level 2

    Yes, thank you!


    Community Code of ConductAccessibility statement