Question about $,$1 values in set analysis

[#1]

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.

[CELAMBARASAN · Accepted solution]

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.