The report has region,months and have measure as section
if the user selects three measures at the prompt, is it possible to do different levels of aggregation for these 3 measure may be one sum,one average,one weighted average in the same report.
Which means the measure 1 section the values of the region aggregated to average, measure 2 section values of the region aggregated to weighted average, and measure 3 to sum and so on depending on the number of measures.
The database has almost 70 measures,so based on the measure selection the aggregation should happen differently.
Is it possible at report level or please suggest any possible solution for this requirement