Sorting Groups for finanacial report

[Dustin_Good1]

I imported YTD numbers based on client payments, I created columns to determine number of billing months and a column to calculate client totals. Then a column to divide # of months and client totals.

Great! I’ve got my numbers. However to clean this up I need to group payments by client and I’d like to sort those groups which is where I’m having an issue.

I’ve looked at other post about this approach but still don’t understand what to do next by looking at other use a cases.

[Scott_Collier-Weir]

You just want to sort it so highest amount comes out on top right?

[Dustin_Good1]

Yes.

As a way around I used my client single select column to create another table and then brought in the average so I can share with others. I acheived my goal of compiling and sharing but now I am curious about how to do the same with groups.