Hello-
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)
