7 Replies Latest reply: Dec 15, 2014 9:35 AM by Bunny V RSS

    pivot table issue for total

    Bunny V

      Here in the above pivot table .... i want the [final performance] Total and the expression for it is ...

      =(if(Dimensionality()=1,

        [Coperate SLP]*Performance))

        mon.PNG

      in this screen shot . At Final perfromance total should be 109+0 how can i write the expression.