I have some Saiku reports where customer uses totals. The final look of the report is this one:
Now the point is that I can have these totals only by selecting a single aggregation function on the dimension Department.
Every time Department changes, Saiku calculates sum OR average OR ... but it seems I cannot have "Sum for Actual" and "Average for some other measure" (maybe Actual - Budget where it would make more sense)
Any idea/suggestion/different tool to work this out?
I don't think this can be calculated on mondrian, because basically those totals depends on member selections on screen. But I might be wrong ... Actually I hope :-)