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'?

  • Apr 17, 2023 12:34 PM UTC
  • 2 replies
  • 136 views

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 Anonymous

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

 

HTH

View original

2 replies

  • Answer
  • Apr 17, 2023 12:47 PM UTC

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

 

HTH


  • Apr 17, 2023 12:48 PM UTC

Yes, thank you!