Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
akuttler
Creator
Creator

Display Field in Pivot Table as a % of Total

Hi I have a pivot table to display the AR balances for Insurance Payers.

Row field is Insurance Name

Measure Column  is Total AR = Sum([Total IB)]

Table display :

INSURANCE NAME:          TOTAL AR:

BCBS                                   32K

CIGNA                                  50K

MEDICARE                         100K

I am simply trying to show the Total AR  as a % of Total

I tried Sum([Total IB])/Sum({1}[Total IB])

But it displays 100% for all the Payers.

Thanks in advance.

1 Solution

Accepted Solutions
sunny_talwar

Try TOTAL instead of {1}

Sum([Total IB])/Sum(TOTAL [Total IB])

{1} is used for ignoring selections

TOTAL is used for show total of your expression across all rows

View solution in original post

2 Replies
sunny_talwar

Try TOTAL instead of {1}

Sum([Total IB])/Sum(TOTAL [Total IB])

{1} is used for ignoring selections

TOTAL is used for show total of your expression across all rows

akuttler
Creator
Creator
Author

Thank so much, it works.