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
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