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

      Hello,

       

      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

      Andrea