3 Replies Latest reply: Mar 2, 2016 7:05 AM by Marcus Sommer RSS

    Set Analysis

    Ridhaa Hendricks

      Hi There


      I need to sum a variable and use set analysis to specify the parameters to sum of that variable...


      Is it possible to use Set analysis like below??? or something like it... when doing it the way I have I just get the full sum of the variable it is disregarding the set analysis which I have specified.

       

       

      vGrossProfit= Sum(Sales)-Sum([Cost of Sales])

       

      vShop1GrossProfit=Sum({<Division={'Shop1'}>}vGrossProfit)

       

      Sum({<Desk={'Desk1'}>}vShop1GrossProfit)

       

      Thank You