Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm very new to set analysis and have a quick question.
I was wondering what is the difference between '1' and '$' when set modifier are given as identical.
for example:
Sum({1<Year={'2013'}>}Sales)
Sum({$<Year={'2013'}>}Sales)
Based on my test, above returns the same results.
If both gives the same result, in which case do i need to use 'Sum({1<Year={'2013'}>}Sales)' rather than 'Sum({$<Year={'2013'}>}Sales)' ?
Thanks.
Difference between $ and 1 will be visible once you will make selections. With 1 in your expression, any selection made won't change the result of the expression, but $ will filter out the selections and give you the results for only those elemets selected by the user. For more details on set analysis, you might want to check out the attached file.
Difference between $ and 1 will be visible once you will make selections. With 1 in your expression, any selection made won't change the result of the expression, but $ will filter out the selections and give you the results for only those elemets selected by the user. For more details on set analysis, you might want to check out the attached file.
Hi,
Thanks,
AS
Thanks for kind reply.