Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Sure
@Shubham_Deshmukh did you find the solution for question, i have the same issue