Forum

Sorting Issues with...
 
Notifications
Clear all

Sorting Issues with Pivot Table

3 Posts
2 Users
0 Reactions
99 Views
(@eileen)
Posts: 4
Active Member
Topic starter
 

I have a Quality Refund Excel worksheet.  Not every customer will get a refund, so I will have a good few blank rows. Not sure if this is what is causing my sort issue. My summary tab is not sorting by 'Code' column and any time I refresh the month columns reduce in size.  I also had to sort the months manually, not sure if there is a solution for this.

Thanks Eileen

 
Posted : 27/10/2021 9:15 am
(@mynda)
Posts: 4762
Member Admin
 

Hi Eileen,

Your data is in the wrong format for a PivotTable. You shouldn't have a separate column for each month. You should have a column that contains the month names and then a column containing the values so that it's in the correct tabular format.

You can use Power Query to unpivot your data into the correct layout, then your PivotTable will sort as desired.

See file attached - Tabular Data sheet. If you'd like to get up to speed with PivotTables, please consider my PivotTable Quick Start course.

Mynda

 
Posted : 27/10/2021 10:33 pm
(@eileen)
Posts: 4
Active Member
Topic starter
 

Thanks Mynda

 
Posted : 28/10/2021 4:17 am
Share: