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.

       

      Picture1.jpg

       

      =If( Measurement# ='M1'

                    ,'Calc 1'

                    ,If( Measurement# ='M2'

                            ,'Calc 2'

                            ,'Other'

                       )

         )

       

      What's missing?

      Thanksin advance,

      Aldo.