I am trying to solve a problem a colleague is having with a simple pivot table.

She has two data elements "Den Rsn Code" and Description. She has two sum values: Count of Den Rsn Code and Sum of Total Balance.

The table is in tabular format. We are using Excel 2016.

We cannot get the table to sort on Sum of Trial Balance. Every sort option seems to only sort based on the Den Rsn Code and/or Sum of Trial Balance.

I have sorted pivot tables by balance in ascending or descending order in the past but I can't work my way through on this one.

I know it is something simple but I am stumped.

Any suggestions?

Thanks to all.