Pivot table not expanded by default

Question & Answer
1

Hello,

Is there a way for a pivot table to not be expanded by default? Now they are expanded and it ruins a % calculation I’m doing on the sum of the values in the pivot table, if I were to sort by that value.

Thanks!

EH

2

Hi @hdezeduardo you can collapse the pivot table fields from the field wells as follows:

image
image903×647 59.8 KB

2 Likes
3

Thank you @darcoli !! But how do I sort by now? It’s not sorting appropriately!