Excel 2019 Pivot Tables & Introduction To Dashboards The Step-By-Step Guide by Benton C.J

Author:Benton, C.J.
Language: eng
Format: epub
Published: 2019-11-17T16:00:00+00:00

For the ‘Import Data’ prompt:

Select the radio button for ‘PivotTable Report’

Select the radio button for ‘Existing worksheet’ enter =$E$3 for the cell location

Click the check box for ‘Add this data to the Data Model’

Click the ‘OK’ button

In the ‘PivotTable Fields’ pane select the following fields:

REGION (Rows section)

MONTH (Columns section)

SALES (∑ Values section)

Right-click over the ‘Grand Total’ field (cell ‘G4’) and select ‘Remove Grand Total’

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.