Sorting Values on Pivot Table

Hello everyone,

I am seeking some assistance with Pivot Table sorting. I have a Pivot table that was created and we have values that are specified in ranges that we want to sort on. For example, our ranges are 1-30, 31-60, 61-90, etc. The issue that I'm running into is that when the column is sorted, it is placing them in an order of 121-150, 1-30, 151-180, etc. I have attached an example screenshot below. Is there a way that we can re-arrange these so that they are sorted in the correct order? I'm not very familiar with Pivot Tables. Any assistance given would be wonderful.

Sorting_Pivot Table.png

Hi,

Unable to open the image you attached.
Are you able to attach a copy of your file for us to look at?

Regards

peterrc

Sorting_Pivot Table.png

Hope this helps.

Hi,

Unfortunately you have attached an image again that I cannot open.
If you are allowed please attach a copy of the actual Excel "xls(x)" file.

Regards

peterrc

Hi peterrc,

I'm not about to post the Excel file as it contain personal data. Is there any other way that I can show you what I'm trying to accomplish?