I like the Pivot Table functionality because it allows me to drill through to the details in another table. A straight table allows that, but not as well in my example. Mainly because I need two dimensions.
I have included in the attached doc some options.
In the end I want a table that looks like this. I can re-model the data if needed so I am open to any suggestions.
Yes
No
Total
%Yes
Red
50
16
66
76%
Orange
57
62
119
48%
Black
30
18
48
63%
Green
98
38
136
72%
When I click on the 16 for No/Red I would like to just see those 16 detail records. While I can get a straight table to look the way I want, I can not get it to select the data I want (Because I am using Set Analysis instead of the Dimension as a Dimension in the chart)
