In a PivotTable, how can a field of data be hidden from the viewer but still be active in calculations made by Excel’s formulas?
A. The user can go to the raw data worksheet and delete the data that is in the field.
B. The user can go to the raw data worksheet and cut the data from the field and paste it into a new field.
C. The user can select a cell in that field and click "Collapse Entire Field" in the Options tab.
D. The user can select a cell in that field and click "Hide Entire Field" in the View tab.