hard20 pts · first answer countsexcelpivot-tables

Grouping one pivot changes another

Two pivots were built from the same source range. You group dates by quarter in one pivot, and the other pivot's dates also become quarters. Why?

A.Excel links all pivots in a workbookB.The second pivot copied the first one's filtersC.Grouping always applies to the whole workbookD.Both pivots share one pivot cache

Discussion 0

Join free to post in the discussion.

Grouping one pivot changes another

Discussion 0

Related questions