I have a confusing question need help. My chart has year, month as dimension, also has category, sub category, vendor, item fields.
What I am looking for is the chart ignores year, but takes month and all fields selection. after spending more than half hour, finally, I got the below expression works,
SUM({<year=>}SALES)
I tried Sum({1-$<Year=>}SALES) but does not work.
I feel the latter expression is more understandable. why doesn't it work? Thanks.
(with the exception when your are using the expression in an alternate state context, but this is probably not your setting)
Why do you think, SUM({1-$<Year=>}SALES) is more understandable? What do you think this set expression describes?(as a side note, field names are case sensitive, so year and Year are different, but I think it's just a typo in your post)
