A data source has grown to forty measures covering finance, logistics, and marketing, and analysts struggle to locate the right field in the long alphabetical list. A lead wants to group the related measures together in the Data pane without changing any field names, data types, or values. Which action achieves this organisation?
- ACreate a relationship that links the finance, logistics, and marketing fields
- BPivot the measures so each category becomes a row grouping in the pane
- CPlace the related measures into named folders in the Data pane Correct
- DHide the unused measures so only one category is visible at a time
Why A is wrong: A relationship combines tables for analysis and does nothing to rearrange how fields are displayed within a single Data pane, so it does not group the measures visually.
Why B is wrong: Pivot reshapes data from columns to rows and would alter the structure and values of the source, which the lead has ruled out, and it does not group items in the Data pane.
Why C is correct: Folders let the analyst gather related fields under named groups in the Data pane purely for navigation, organising the forty measures without touching field names, data types, or values.
Why D is wrong: Hiding removes fields from view rather than grouping them, so analysts could not see all categories together and the related measures would still not be organised.