Hope one of you could maybe help in this regard. I have a pivot table in which the columns are aggregated by SUM, but I want them to aggregate by Average on each respective level. Also, something to note, the “utilisation %” measure is wrapped in a variable called vUtilisation – can I use a variable inside an Aggr function?
I tried the following, but to no avail:
Avg(Aggr(Sum(vUtilisation),cf_business_line, cf_practice, CO_EM, Resource_Name, Project))
Any help will really be appreciated.