we cannot summarize this field with sum because

#WE CANNOT SUMMARIZE THIS FIELD WITH SUM BECAUSE PLUS#

However, this functionality is provided in PowerPivot within MsExcel, which is using the DAX expression to create 'measures' (simular to calculated fields but can be manipulated with DAX functions). This does not seems to work in plain old pivot table. max of a certain group of cells, you may say they are calculated fields which can be manipulated more) to tell excel the expression to compute the value for a group of cells for you. I suspect the plain pivot table function in excel is not enough to compute the min() and max() in a certain pivot table set, since the min() and max() functions are supposed to work in a row-by-row basis only.

Below is example data if you want to try.

#WE CANNOT SUMMARIZE THIS FIELD WITH SUM BECAUSE PLUS#

I am using Excel Professional Plus 2016 on Windows 10. The image below shows the results of the two calculated fields described above (in red), and a simple formula outside the PivotTable, which gives the desired result (in green). It is easy to do with a formula outside the PivotTable, but I would like to do this within the PivotTable so I can chart it and add new data in the future. =SUM(MAX(' Item 1'), MAX(' Item 2')) and =SUM('Item 1','Item 2').īut this sums all the values from that month for Item 1 and Item 2, not only the maximums. I have tried used a calculated field with both: I then want to sum those maximum values, to get a total of the maximum for Item 1 and Item 2, in the PivotTable. I want to make a PivotTable with the maximum monthly value for I have a table with dates, and two value columns, Item 1 and Item 2.

We cannot summarize this field with sum because