The attached workbook has 1 dashboard with 2 sheets in it. Summary worksheet is a simple donut chart where outer pie is showing internet usage per each region and where inner pie is showing overall internet usage for all regions and Detail worksheet is a simple cross tab showing internet usage per each region in a tabular form. I'm doing a simple filter action on my summary worksheet i.e. Donut Chart. My filter action works fine if I select any region in the donut chart, the cross tab shows value for that region only. But what I want is, if I select the inner pie of the donut chart, the cross tab has to show all regions with their internet usage value and when I clear the selection, the crosstab has to become blank. Does anybody know how to do this?
Is it possible to union your data to itself?