1 Reply Latest reply: Jun 15, 2018 8:05 AM by Johan Joubert RSS

    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?

       

      Pivot Table.jpg

       

      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.