Grouping selection in Pivot table makes all data disappear
 

I can select a few rows and say group. Then the status bar says its
connecting to the database and executing the query. Once it finishes though,
the data all disappears and I'm left with just the Row and Column headers.

Any ideas?