• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Different aggregations in same pivot table

wrijneveld

New Member
Hello,

Does anyone know if it is possible to use different aggregation methods in the same pivot table?


I have a datafile with results for different indicators. They need different types of aggregation: SUM, MAX or AVERAGE. In my source data I have made a column that indicates for each record the type of aggregation. I want to summarize this in one pivot table.


The solution I tried is: include the values field 3 times and specify different aggregation methods for each. However, then I get ALL values SUMmed, AVERAGEd and MAXed, but I want only some SUMmed, some AVERAGEd and some MAXed. And when I apply filters, they apply to the whole pivot table and not to the specific data field only.


Any solution apart from having separate pivot tables?


regards, Wouter
 
Good day wrijneveld


I have done this once, and I did all the aggregation in columns in the data table and then made the pivot, it worked and is neater that trying to do it in the pivot. I filtered in the table and then refreshed the pivot.
 
Back
Top