set analysis basic question

[surajap123]

HI Experts,

I have a doubt on the importance of $ symbol in set analysis

sum({$ <Year={2007,2008}>} Sales) --->returns the sales for the current selection

I dont understand the statement. Does it mean the above expression returns sales amount when user clicks on 2007 or 2008 year?

I always have this doubt with $ symbol in set analysis. I dont understand what current selection has to do in the expression.

Could anyone give me explaination with examples.

Thanks a lot !!

Regards,

Suraj

[Gysbert_Wassenaar · Accepted solution]

It means it will return the sales of both 2007 and 2008 no matter what year the user selects. The $ means that for the other fields the selections of the user are applied. Only the Year field is overruled by the set modifier Year={2007,2008}.

[swuehl]

This statement changes the selection in Year to 2007 and 2008 selected, while keeping all other compatible selections, like selections you may have made in Country or Customer.

If the user selects something different in Year field, his selection will be overwritten with 2007 and 2008 for this aggregation.