To enable grouping by a field in Pivot, which setting must be enabled?

• A. Allow Pivot
• B. Allow Group By
• C. Relational
• D. Propagation

Answer: (B)

Grouping data in a Pivot requires enabling the option that allows a field to be used as a grouping dimension. The setting that does this is Allow Group By. When this is turned on, you can treat that field as a category or dimension in the Pivot, placing it in rows or columns to produce grouped totals and summaries. Without this enablement, the Pivot won’t let you form groups by that field, even if the field exists and contains values. Other options don’t unlock grouping by a field: Allow Pivot simply turns the Pivot feature on, while Relational and Propagation refer to different capabilities and don’t affect whether a field can be grouped in Pivot.