Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Im attempting to use set analysis to see sales for a given year in this case 2012.
My expression is :
=$(vSumSales)
What would the correct syntax be ?
Thanks
Sum({<Year="2012">}Sales)
regards
Hi Sid,
Try something like this:
=Only({$<Year={2012}>} Sales)
Regards,
RK
Sum({<Year={'2012'}>}Sales)
My bad i miss {}
Try below
Sum({<Year={"2012"}>}Sales)
Regards