2 Replies Latest reply: Dec 27, 2017 12:46 PM by Ashley Kuttler RSS

    Display Field in Pivot Table as a % of Total

    Ashley Kuttler

      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.