How to display only the grand totals in a worksheet

If there is a time where you need to just display the grand total rather than the whole data just follow these steps. You might have a report as shown below:

And now that the report is here and you just need to show the Grand Total, all that you need to do is remove the pills that are there in the rows shelf which generally would be dimensions. After removing them from the row shelf. See how it finally looks after removing the pill from rows shelf:



No comments:

Post a Comment