report filter sort

  1. M

    Report Filter - Can I filter one drop down based on another?

    I have a pivot table in Excel 2007 where I would like to have two report filters. If I select a value in the one drop down filter, I would like only those valid options to appear in the second drop down filter to appear. In my example, The one field (COMPANY) in my table contains a list of...
  2. L

    Change a Pivot Table Report Filter Using a Data Validation List

    I have a spreadsheet that has multiple work sheets which each have a pivot table with Year and Month Report Filters. I'd like to be able to select the Year and Month via Data Validation Lists on the front sheet (my dashboard) and automatically have the Pivot Tables update in the other work...
  3. E

    Pivot Table Report Filter Sort Question

    I have Pivot Table (Excel 2007) that contains a Report Filter of Employee Names and Hours Worked. When I append new data for new employees, how do I sort the entries in the Pivot Table Report Filter to include the new employees in Alphabetical Order. Currently, the new employees are at the...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top