Excel QuickBytes# 3: Pivot Table Field List Settings

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


@imvivran

Drop Me a Line, Let Me Know What You Think

 

contact@vivran.in

+91 9871-641-146

Join WhatsApp group: BI Simplified

MS EXCEL || POWER BI || POWER APPS || POWER QUERY || TABLEAU || DATA ANALYTICS || TRAINING