8 Replies Latest reply: Nov 21, 2012 3:23 PM by whiteline _ RSS

    Custom Labels in Pivot Table

      Hi all

       

      I've an issue and I need your help! I need to custom the subtotal labels of a pivot table. Imagine a pivot table with 3 dimensions and, for example, the third dimension has two subtotal labels. By default those 2 would have the same name but I need to have different names according to my needs...

       

      I already try an expression like: if(Dimension 2='X', 'Total 1', 'Total2')

      The QV always enter in the else part no matter the condition...

       

      There's another way of doing that?

       

      Thanks in advance.

       

      Kind regards,

      TMF