# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Honored Contributor

## Percentage Rollup

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?

1 Solution

Accepted Solutions
Highlighted
MVP

## Re: Percentage Rollup

Try this:

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

Assuming CategoryDesc is your highest dimension here

4 Replies
Highlighted
MVP

## Re: Percentage Rollup

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

Highlighted
Honored Contributor

## Re: Percentage Rollup

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

Highlighted
MVP

## Re: Percentage Rollup

Try this:

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

Assuming CategoryDesc is your highest dimension here

Highlighted
Honored Contributor

## Re: Percentage Rollup

Perfect.  Thank you.