Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI all,
pls do me a favor .
my requirement is to calculate ytd ...where the expression should contain selected year and all months including current selection. example month selected is march then it shud display data for jan, feb and march along with selected year...!
kindly help on this with the expression !!
any help on this will be much appreciated
Try this sintax:
SUM({1<YEAR = {YEAR}, MONTH = {"<=$(#=ONLY(MONTH))"}>}SALES
Thanks buddy ....cud u pls tell wat does 1 signify in syntax..?? )
The number 1 ignores the of selections made.