IF SUM([Sales]) > LOOKUP(SUM([Sales]),-1) THEN 'UP' ELSE 'DOWN' END
Thanks for the quick reply.
I am getting an error in my calculated field, it says : 'Argument to SUM (an aggregate function) is already an aggregation, and cannot be further aggregated.'
This is probably becuase my mesure is an Aggregation. Is there anyway around this problem?
I'm currently away from my desk.
I'm pinging myself as a reminder to reply when I'm able...
We need to look at the aggregation of the previous calculation
there is some interesting discussions here on sum, window_sum vs total