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,