Does anyone have an answer to this. I'm running into the same problem. How do you top 10 by the Grand Total column?
I've encountered something similar. I found a work around when I selected the "show empty rows" option.
-- Table Layout
--- Show Empty Rows
You might want to give that a shot..
I know this is like four years after the fact, but were u ever able to crack this. I have the same issue