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

Question

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?

Page 1 / 1

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

HTH

Yes, thank you!

Reply

guillermo.gost12 · Accepted Answer

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

maximilian.alter · Answer

Yes, thank you!

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN