1 Reply Latest reply: Jun 30, 2015 1:05 PM by Oleg Troyansky RSS

    My Variable having a SET Analysis but it is not getting filter base on dimension.

      Hello,

      I have a variable called NetTrunOver with following SET command.

      =sum({$<PLGroupName={'NET TURN OVER'},PostingFinYear={$(vMxYear)}>}GL_Amount)

       

      RegionLocation-1Location-2Location-3
      PLSubGroupName
      NET TURN OVER123567890

       

       

      and i just wanted to use use this variable in a Pivot Table to display the location wise trend info using above variable but it is not getting filter base on the location dimension.

      Please help,

      thanks..