I would like to know if there is any way to automatically display the Row Label Filter similar to what is done for the Pivot Table filters.
I have attached a Microsoft Excel Pivot Table practice file in which I have entered fictious employee names. I am a beginning Pivot Table user and this is my first Pivot Table, so please excuse if it is not set up for optimum use.
If you open the Microsoft Excel Workbook and go to the Worksheet labeled Pivot-04 there is a Row Label Filter in cell C5 called Enter Time Minutes. This Row Label Filter selection is set to Between to display Enter Time Minutes is between 360 and 599. This is the equivalent of 6:00 AM and 9:59 AM.
I am currently manually typing in this Row Filter Information in cell H5. This is the result I would like to achieve.
I would like to have some way of automatically displaying this Row Label filter is this cell as there will be times, I want a different filter range.
Currently the Pivot Table filters are shown automatically. See the following cells.
1. UserNbrName Cell C9
2. UserNbrName Filter Display Cell D9
3. DoorNbrName Cell C10
4. DoorNbrName Filter Display Cell D10
5. Year Cell C11
6. Year Filter Display Cell D11
7. MonthNbr Cell C12
8. Month Nbr Filter Display Cell D12
I want the Row Filter Display to be similar to Cells D9, D10, D11, and D12. Desired Result.
This way if I change the Row Filter Information it will be visible in a similar fashion.
When I look at data, I want to know how it has been filtered.
Any suggestions as to how I can do this would be appreciated.
Bookmarks