I have an application that provides data on a particular survey. Respondents can answer on a number of products, say a, b,c,d. They can selected any number of these 4. What I want to do is show this data in a chart such that for each product I have a bar showing a count of those RespIDs who selected the product and another bar showing a count of those doctors that didin't select the product.
I've attached a small app that shows what I'm trying to accomplish and would appreciate anyones feedback. The first part is easy and I've done this, it's the second bit eg: identify a count of those respondents that didn't select the product. I tried using 1-$ but there are mulitple other filters in the app that I need to include so cant take this approach.
Thanks this gives me some idea's to play around with. Howerver, it's not quite what I needed. Without filtering on a product the blue bars show those products selected (prescribed in my live version), however, I want to show, on the same chart, the Products that the doctors haven't prescribed.
So looking at the text box in my examply you see that 3 Doctors have prescribed product a, but 2 havent. I want to show these 2 in a red bar next to the 3 that have prescribed the product.
I hope this makes sense. Again thanks for your help