Sorting Pivot Table by Negative Percent

**greyfox8991** · 08-03-2022, 09:22 PM

Hello,

I have a Pivot Table that I created showing Year over Year (YOY) changes and I would like to sort this Pivot table to show Negative Values on top. I am showing years 2019,2020,2021, and 2022 and I would like to show the negative(YOY) for each year on top of the table. Is there a way to accomplish this. I am attaching a screenshot to show a sample of what the data looks like. The highlighted items are the percents however i am only focusing on the negative values.

I would like to end result to be: Negative YoY percent values on top in this pivot.

**Kaper** · 08-04-2022, 03:18 AM

But ... there is something as row labels (on the left from the area of your screenshot), and you cannot sort the same way all 3 columns without breaking the connection to row labels.

Probably you can prepare separate pivot table for each year and then sort each on %YOY descending. Then the sequence of row labels will be different in each table.

Sorting Pivot Table by Negative Percent

LinkBack

Thread Tools

Rate This Thread

Display

Sorting Pivot Table by Negative Percent

Re: Sorting Pivot Table by Negative Percent

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Pivot Table with Both Number and Percent Row

Pivot Table Percent Calculation

Pivot table not calculating negative numbers properly + not sorting months accurately

Percent difference in a Pivot Table

Add simple a1/b1=c1 as percent in pivot table

Pivot Table Percent Of

Pivot Table - Percent

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions