Forum Discussion
Solved
Pivot tables - summarization of the value
Hello.
I wondering how can I make that my pivo table always choose first in value the summarization instead of count. It takes to much time to change it every time when I do my reports.
Thank you in advance
Kind regards Erika
I wondering how can I make that my pivo table always choose first in value the summarization instead of count. It takes to much time to change it every time when I do my reports.
Thank you in advance
Kind regards Erika
Hi Erika,
By default Pivot Table use SUM aggregation if your fields are numeric and COUNT if there are some blank or text fields.
For my knowledge it's not possible to change this behaviour from UI, only using VBA or third-party tools.
Pivot tables sums values in value field of pivot table, if the column with data have numeric values, however if data has blank or text or error, then it detects that the data is not numeric so it counts in stead of sum.
if you have multiple columns in value field of pivot table and chanding them manually bothers you.
then there is a free pivot table Add-In that you can download and use for free, where multiple columns value field setting
Hi Erika,
By default Pivot Table use SUM aggregation if your fields are numeric and COUNT if there are some blank or text fields.
For my knowledge it's not possible to change this behaviour from UI, only using VBA or third-party tools.
- Thank you. It sounds logical.
