Which setting makes the field available to group by when using Pivot?

• A. Allow Pivot
• B. Relational Field
• C. Allow Group By
• D. Import Behavior

Answer: (C)

Grouping data in Pivot depends on a field being marked as groupable. The setting that makes a field eligible to define groups is Allow Group By. When this is enabled, the Pivot engine recognizes that field as a dimension you can use to split your data into distinct categories, letting you build aggregates (like counts or sums) by each group value. Without this flag, the field may be usable in the Pivot for other purposes, but it won’t appear as a grouping option.

The other options don’t provide this grouping capability. Allow Pivot controls whether the field participates in Pivot operations in general, but it doesn’t specifically enable grouping. A Relational Field describes connections to other data rather than whether the field can be used to define groups. Import Behavior governs how data is brought in, not how it’s grouped during analysis.