4 Replies Latest reply: Nov 12, 2012 1:14 AM by Aldo Liaks RSS

    Pivot Table - Change Expression titles - labels - by expression value

      Hi Guys,


      Please see the qvw attached.


      I should be able to set different labels in Expression 3 following the values in field Measurement#.

      I am using the script below.  The label should be different for each "Measurement#", but I get the value "Other" in all cases.




      =If( Measurement# ='M1'

                    ,'Calc 1'

                    ,If( Measurement# ='M2'

                            ,'Calc 2'





      What's missing?

      Thanksin advance,