Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Thank so much, it works.