I have a rather simple Cross tab
Columns1 (Year)
Rows = Customer Name
My Column1 will have only 2 years (2018 and 2019). I would like to sort the Customer Names based on the numeric values in my 2019 Column.
I can not figure out how to configure that so that it could be dynamic. Meaning my 2 years might not always be 2018 & 2019...maybe 2016 & 2017.....But I always want to sort by the larger of the 2 years.
Any suggestions would greatly be appreciated.