Pivot Tables In Depth For Microsoft Excel 2016 by Suljan Qeska

Author:Suljan Qeska [Qeska, Suljan]
Language: eng
Format: azw3
Published: 2017-08-28T04:00:00+00:00

Once you have done this the Pivot Table will look like in Fig 6.11 with Qtr1-4 added to the bottom of the table.

Fig 6.11: Pivot Table with Calculated Items for the Month field

To move Calculated Items to a more suitable position let’s use the Move functionality as in Fig 6.12. Select the cell with Qtr1 and then right click and go to Move and then select Move “Qtr1” Up. Repeat until you reach the desired row. Do the same with the other Calculated Items.

Fig 6.12: How to move Calculated Items up or down a Pivot Table

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.