Sum of Averages in Spotfire
I thought it would be very easy, but I've been struggling for days to make this simple query work. What I need is an expression that gives me the sum of averages.
(Due to filtering requirements I can't pivot my data table or use calculated columns, it has to be an expression).
|Sum of Averages:||55|
So Avg(cat1) + Avg(cat2) = 55 is what I'm after, but no matter what I try I just can't make it work. Any help would be extremely appreciated!