Virgilio Pierini

How to calculate both Sum and Avg Totals in Saiku

Discussion created by Virgilio Pierini on May 24, 2018

Hi members,

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 :-)