Skip to Content
0
Jun 08, 2020 at 10:04 PM

How to sort Cross Tab by a Column

41 Views

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.