Display Field in Pivot Table as a % of Total

[akuttler]

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.

[sunny_talwar · Accepted solution]

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]

Thank so much, it works.