HOW TO AGGREGATE PIVOT TABLE COLUMNS BY AVERAGE

[johan_joubert]

Hi Everyone,

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.

Thanks.

[johan_joubert]

So any chance anyone knows how to use a variable inside an aggregation function?