2 of 2 people found this helpful
The view data menu option isn't intended to be used the way you are using it - its an access point to be able to view all of your data that you have loaded in crosstab mode.
I believe what you are looking for is a filter of your data, to achieve this simply duplicate your sheet and then put both sheets onto a dashboard, convert the second one to crosstab mode and turn filters on in the first. This will filter the second sheet by the values you have selected in the first sheet.
Thank You so much for your input...