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.