Percentage Rollup

[rittermd]

I have a Pivot table as shown below.

Right now the Days% is calculating for each section as a part of the whole total.  What I want is for each section to total up to 100% ignoring the other sections.

For example in Medicare A RUG Mix for Ultra High RUB I want that to display 85.86% (346/403) instead of 61.24% (346/565)

Is this possible to do in Qlik Sense?

[sunny_talwar]

Can you share your current expression and the name of your dimensions?

[rittermd]

If (dimensionality() = '1' OR dimensionality() = '4',Sum(RugDays)/Sum(Total RugDays),' ')

[sunny_talwar · Accepted solution]

Try this:

If(Dimensionality() = 1 or Dimensionality() = 4, Sum(RugDays)/Sum(Total <CategoryDesc> RugDays),' ')

Assuming CategoryDesc is your highest dimension here

[rittermd]

Perfect.  Thank you.