1 Reply Latest reply: Jul 12, 2012 5:16 PM by Celambarasan Adhimulam RSS

    Question about $,$1 values in set analysis

      Hi,

       

      Can somebody explain how does $,$1  impacts set analysis expression.

       

      For e.g. I created set analysis to count only 'Fruit' produce from inventory and it worked well for me.

       

      = Count({$<[Type]={Fruit}>} Type)

       

      But this raised a question in my mind, what does $1,$2 will indicate instead of only adding $.

       

      Can somebody please elaborate.

        • Re: Question about $,$1 values in set analysis
          Celambarasan Adhimulam

          sum( {$} Sales )
          returns sales for the current selection, i.e. the same as sum(Sales).

          sum( {$1} Sales )
          returns sales for the previous selection.

          sum( {$_2} Sales )
          returns sales for the 2nd next selection, i.e. two steps forward. Only relevant if you just made two Back operations.

          sum( {1} Sales )
          returns total sales within the application, disregarding the selection but not the dimension. If used in a chart with e.g. Products as dimension, each product will get a different value.