Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have the data 2011,2012,2013,2014.when ever we clik on 2012.it gives 2012 to 2014 data.and we clik on 2013 it gives 2013 to 2014 data.ho w to write the set expression
HI
try this
sum({1<YEAR = e(YEAR)>}sales)
Hi,
Try like
sum({<YEAR = {">=$(YEAR)"}>}sales)
Regards
Hi,
Try below code:
Sum({<Year = {">= $(=Max(Year))"}>} Sales)
HTh
Sushil
hi,
Use following expression
=sum({$<YEAR = {">=$(=max({<YEAR={$(=max(YEAR))}>} YEAR))"}>} Field)
YEAR- Year Dimension
Field - The field name you want the summation
Rgds,
Dinu'1