QuickBytes is a series of articles for simple and easy to implement techniques with exponential benefits
The Pivot table is quite a versatile feature and quite popular. This article covers two settings, which enhances the user’s experience while using a Pivot Table.
Field List Layout
We get the following layout for the Pivot Table Field List:
It works fine if the list of fields is small. However, I find the following layout more useful:
It offers better visibility of the field lists and convenient to use, especially in small screens.
To enable this, click on the gear icon > Fields Section and Areas Section Side-By-Side
Sort Items in the Field Lists
By default, the sort order of the items in the field lists are according to the data source table:
It becomes a challenge to find any specific field if the list is long. I prefer sorting it in alphabetical order, which makes the finding the field more convenient as our mind is trained for finding words in alphabetical order:
Click on the gear icon > Sort A to Z