Automatically Sort a Pivot Table After Filter

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