Which setting makes the field available to pivot on?

• A. Allow Sort/Tally
• B. Allow Group By
• C. Relational
• D. Allow Pivot

Answer: (D)

Pivoting relies on marking a field as eligible to be used in pivot views. The setting that enables this is the option to allow pivot for the field. When a field is set to allow pivot, you can work with it in Pivot tables by placing it in rows or columns and summarizing data across its categories. Without this flag, the field won’t appear as a pivot option, even if the data exists.

Other settings serve different purposes. Allow Sort/Tally lets you sort or count entries but doesn’t make the field available for pivot analysis. Allow Group By enables grouping in certain views, which is related to aggregation but not the explicit pivot capability. Relational deals with linking the field to related objects and likewise doesn’t grant pivot functionality.