Pivot table not expanded by default

[hdezeduardo]

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

[darcoli]

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

[hdezeduardo]

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

[Kellie_Burton]

Hi @hdezeduardo -
You should be able to sort on the columns either asc or desc. You can see the sort options on the screenshot @darcoli provided.