Data sorting in Pivot tables by field rather than columns
I use slicers to connect with multiple pivot tables showing date for multiple (2017, 2018, 2019) years and set them to sort data in descending order by 2019 column.
Sometimes if a select a parameter on the slicer pertaining to some data which deos not exist in 2019 (a discontinued product or customer), the pivot table stops showing that year (2019, on which the sorting is set) and when the filters are removed, the sorting order also gets reset to default on all the connected pivot tables.
It would be helpful if the sorting could be done on a field value (Year 2019 then 2018 then 2017 (for example) rather than the column "N" where 2019 data falls.
In this case, even if the data for 2019 does not exist and pivot table shrinks to one less column (for 2019) it would still show data for 2018 and /or 2017 in descending order and revive back to original setting for other selection where 2019 data does exist.