Sorting by values in pivot table

[excellearner09]

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 Labels	YTD	Rolling 12m	Quarter ending
Jan
London	26	26	26
Somerset	60	60	26
YORK	60	60	67
Crewe	26	22	27
Manchester	77	72	72
South Somerset	67	67	63
South West	60	26	67
Sheffield	22	26	25
Feb
London	26	26	26
Somerset	60	60	67
YORK	60	60	60
Crewe	26	22	26
Manchester	77	72	20
South Somerset	67	67	67
South West	26	26	22
Sheffield	22	26	27 ... Dec

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

 

[Worf]

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