Hi
Is it possible to get a conditional sum, ex. (sum values for a, b, c). Similar to a sum if, but involving multiple values?
Please let me know.
Thanks,
Anna
Anna,
This should be doable as an if/then statement. It will depend on whether you want an alternative aggregation (avg, min, etc) or just to combine members of a dimension. Here's an example:
If [Dimension] = 'a' or [Dimension] = 'b' Then SUM([Metric]). END
Let me know if you have any other questions.
-Wesley