Hello team,
I insert a pivot table. I want to use no calculation on some of fields. Once I right click on the field in pivot table field section to select no calculation, it doesn't change it to no calculation, it is still showing sum.
Any tips?
Regards,
BittenBitten
Insert a pivot table and selecting no calculation
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
-
- Administrator
- Posts: 78474
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Insert a pivot table and selecting no calculation
A value field in a pivot table ALWAYS uses some kind of aggregation. You select this in the 'Summarize Values By' tab of the 'Value Field Settings' dialog. You cannot select None or 'No Calculation' here.
In the 'Show Values As' tab, you can specify whether the value field should be displayed as a percentage of the row total or various other options. If you select 'No Calculation', the field will use the aggregation function selected in the 'Summarize Values By' tab without further manipulation.
In the 'Show Values As' tab, you can specify whether the value field should be displayed as a percentage of the row total or various other options. If you select 'No Calculation', the field will use the aggregation function selected in the 'Summarize Values By' tab without further manipulation.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans