Sorting by values in pivot table

excellearner09

New Member
Joined
Feb 22, 2019
Messages
2
Hi all,

I have looked online but can't seem to find an answer to this. I have currently filtered the date by specific year which looks like below. What I am trying to do is use a slicer so that I can choose between dates and also get a text return linked in but I cannot seem to figure out how to sort by YTD, rolling 12m or quarterly since they are values and numeric.

Ideally, I would like to use a text link on a dashboard map. So London will equal A2 which will be January data for YTD, but I want to be able to filter so that I can get the same results for rolling 12m etc.

I current have 'Years' in filter, Under Rows I have date and location and under values YTD, 12 month rolling and quarter ending in the Pivot table

Many thanks in advance.


<tbody>
</tbody>
Row LabelsYTDRolling 12mQuarter ending
Jan
London262626
Somerset606026
YORK606067
Crewe262227
Manchester777272
South Somerset676763
South West602667
Sheffield 222625
Feb
London262626
Somerset606067
YORK606060
Crewe262226
Manchester777220
South Somerset676767
South West262622
Sheffield 222627
... Dec

<colgroup><col span="6"></colgroup><tbody>
</tbody>
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Welcome to the Board


- A pivot table may be converted into a normal table by copying and then using paste special/values. This new table can be useful in some situations.
- To quickly sort a pivot table column, right click a value cell and choose sort. See page below for more information.
- The GETPIVOTDATA worksheet function can be used to transfer individual pivot cells to other locations.

https://www.contextures.com/excel-pivot-table-sorting.html
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,507
Messages
6,114,029
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top