19 Replies Latest reply: Oct 21, 2016 3:50 PM by Prasanna Sankepalli RSS

    Label for Totals Expressions in Pivot Table

      Hi All,

      Please see the attached screenshot below for the pivot table in question.

      error loading image

      I'd like to add labels at each level instead of the 'Total' currently shown.


      The total for the Account column should show the NetAssetGroup, likewise the total line under the Activity column should show the Account group. I've tried various formula, only succeeding when selections are made.

      The text should display when no selections are made.

      Thanks in advance.