Combine filter on Pivot table and non-pivot data

cgmojoco

Well-known Member
Joined
Jan 15, 2005
Messages
699
Hi there-

I have a pivot table on the left hand side of my worksheet

I have columns to the right of that pivot table that I use to add comments to data in the pivot table.

How can I apply an autofilter to the pivot table so that when I change the row criteria in the pivot table the data in the columns to the right of the pivot table sort/hide/show along with the pivot table?

I've seen settings where an autofilter is applied to the pivot table, but I cannot figure out how to do that...
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Ok---figured out the autofilter over the pivot--- if you goto the right most column (the data that is not in the pivot) and you select the cells on the same row of the pivot table then drag left to include pivot headers, you can autofilter (the option will not be grayed out). That sorts the entire sheet as a whole...so all rows line up between pivot and extraneous columns

Now I have a new problem. The autofilter breaks down the line item of the pivot table and the total item of the pivot table separatley. Any quick way to keep those together so that I can just show the line item and total at the same time when selecting the row criteria of the autofilter?
 
Upvote 0
:eek:
So is there no way to have a pivot table and the adjacent rows sort/hide/show together?....

How can you add notes to pivot table information to the right hand side and have that update with the visible pivot table rows?
 
Upvote 0

Forum statistics

Threads
1,214,788
Messages
6,121,603
Members
449,038
Latest member
Arbind kumar

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
Back
Top