7 Replies Latest reply: Feb 13, 2017 12:17 PM by Marcelo Mtanous RSS

    Pivot Table: how to show expression only in total

    Andrea Gigliotti



      I have a pivot table with 2 dimensions and two expressions.

      I need to show the second expression value only in total column and finally I did it using SecondaryDimensionality() = 0 as condition.

      Now I have to hide all columns of second expression values for each value of second dimension and show it only in total.


      How can I achieve it ?


      Many thanks in advance.


      Best Regards