I don't know if this is possible. I have not been able to get it to work. But it seems like it should.
I have created a stacked bar chart. I have two expressions being displayed as bars. The charts dimension is the Therapeutic Class of the drug. The two bars display the percentage of generic and brand scripts in that class.
The chart is built on Top N based on the total number of scripts that have been written in that class. That works fine.
What I want to do next is sort those Top25 by the Brand percentage in descending order. It will not do that. I have tried any number of combinations and have not been able to get this to work.
Please help. I need to get this figured out quickly.
Thanks.
