Tuesday, June 23, 2020

Include Filtered Items in Totals for Pivot Table

Pivot tables are great analysis tools, but sometimes (or often) Microsoft adds a feature and doesn't make it obvious on how to use it. This is one of them. When you have a Pivot table and decided to use the Top 10, Top 5 or Top whatever option to filter your table, it will show the total and subtotal respective to that smaller Top X filter. But what if you still wanted to see how your variables place in the whole data set irrespective of the filter? There is that option to see it as the "Include Filtered Items in Totals" command, but it may be greyed out. See the video to learn about how to fix this.

1 comment:

  1. If you know how to do this before you go into any kind of meeting with the lender, you will find that you will be able to get the best deal possible on your home.If you want to get more interesting details about home buying mistakes, you may go here.