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