... instead of rolling up the the different levels in Pivot table results are summed on each level. For example if I have value (.092) aka 92% or (92) aka 92% at the next group level results are added together instead of a Median rollup.
If you want to do a sum of median averages then you need to nest aggregation functions. You need the aggr function for that: sum(aggr(avg(MyValue), MyDim1, MyDim2, ..., MyDimN)). Replace avg(MyValue) with your current expression and replace MyDim1, MyDim2, ..., MyDimN with the dimensions of your pivot table.
