Automatically Sort a Pivot Table After Filter

**charlesfarrell** · 11-15-2018, 10:27 PM

Hi Everyone,

I think this maybe something simple that I am just missing so I appreciate your patience.

I have a chart linked to pivot table that is then filtered via a slicer.

When I filter, the chart updates but is no longer from largest to smallest. I can go back and resort the pivot table to correct but is there anyway to make this happen automatically when I filter, or can I sort the table to appear from largest to smallest?

I have attached the file so you can see what I mean.

Thanks,
Charles

**kersplash** · 11-15-2018, 10:32 PM

The 2 charts on your dashboard aren't linked to pivots (not that I can see anyway), they are linked to data outside of the pivots.

**charlesfarrell** · 11-19-2018, 01:04 AM

Yes that's correct, apologies I should have been more clear in my description.

However the challenge remains the same, although the chart is reading from the additional data, if I could auto sort the pivot table to always be from largest to smallest then the additional data would do the same and the chart would display the largest to smallest.

Is there a way to sort the pivot table automatically after the filter has been applied, at the moment I have to select the pivot table and then sort, I don't want users having to do this.

If its not possible, would you have any suggestion of an alternative way?

Much appreciated, Cheers,
Charles

Automatically Sort a Pivot Table After Filter

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Automatically Sort a Pivot Table After Filter

Re: Automatically Sort a Pivot Table After Filter

Re: Automatically Sort a Pivot Table After Filter

Thread Information

Users Browsing this Thread

Similar Threads

Two pivot tables with the filter of pivot table 2 to automatically update to filter 1

Two pivot tables with the filter of pivot table 2 to automatically update to filter 1

Cannot filter or sort in a pivot table

Automatically Ignore/Filter/Sort Blanks from a Pivot Table before creating Chart Using VBA

Pivot table or filter to sort data?

how do i automatically sort data in a pivot table

how do i automatically sort data in a pivot table

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions