Question: a 2. Click cell A2. Insert the last Recommended PivotTable-Sum of Amount by Park. Change the PivotTable Name Goypt1 and then add the Month field
a
2. Click cell A2. Insert the last Recommended PivotTable-Sum of Amount by Park. Change the PivotTable Name Goypt1 and then add the Month field to the Rows area below Park. Add the Item field in the Columns area, and then Close the PivotTable Fields pane. (Mac users, be sure that Park displays above Month.) I 3. Insert two slicers, one for the Park field and one for the Item field. Move the slicers so that they are to the right of the PivotTables Apply Lavender, Slicer Style Light 4 to the Park slicer and Light Orange,/Slicer Style Light 6 to the Item slicer. PILLA 4. Use the slicers to filter the PivotTable by Memorial Park, and then by Golf Fees. Change the Number Format to the Number category and display RIVA zero decimal places and the 1000 Separator. Move the Park slicer so that its upper left corner aligns with the upper left corner of cell E3. Move the Item slicer so that its upper left corner aligns with the upper left corner of cell H3Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
