I have an Excel Pivot Table that I want structured like:

State - City - Last Name - Product - Sum of Sales

I want the end result to Group (sort by) State, City, sum of Sales
descending. This report would show the top sales dollars by city, and list
which products sold and by whom.

A Last Name can show up more than once depending on the total sales of
product.

The challenge is that I keep getting a group by Last name which affects the
sort order.

End result that I want displayed

Georgia Atlanta Sally Blue cars 10,000
Georgia Atlanta Bob Green cars 9,000
Georgia Atlanta Bob Blue cars 8,500
Georgia Atlanta Sally Red cars 8,000

Is there a solution to this?

Thanks