Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
... 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.
Hi Parrish,
Is it possible to share a sample QVF?
Thanks,
Sangram.