Category: Excel PivotTables

Faraz Shaikh2 Comments on Dynamic Solution with Power Query to Move the Grand Total in Excel PivotTable

Dynamic Solution with Power Query to Move the Grand Total in Excel PivotTable

While we are working with PivotTable in Microsoft Excel the Grand Total columns always appear on the right side and at the end of the records. One of my friends ask me if it could be possible to move the Grand Total column to the beginning of records as it would help to see the totals first and then the rest of the value.

Faraz Shaikh1 Comment on Move the Grand Total to the left or to the first column in Excel PivotTable

Move the Grand Total to the left or to the first column in Excel PivotTable

While we are working with PivotTable in Microsoft Excel the Grand Total columns always appear on the right side and at the end of the records. One of my friends ask me if it could be possible to move the Grand Total column to the beginning of records as it would help to see the totals first and then the rest of the value.