It is hard to tell how the calculations should be computed without seeing the workbook. However, have you tried sorting State by CNTD(Policy Number)?
Are you able to mock up and post a sample of what is being done?
1 of 1 people found this helpful
1. Remove your Rank pill from the shelf, it will not work since you want to sort based on the result of a table calc
2. Create a calculated field with a formula like:
3. Right-click on this new field in the list of measures, and select "Convert to Discrete"
4. Place this new fiedl as the fiest pill on the Columns shelf, as you had with Rank
5. you will now have the sort you want, and you can hide the header for this pill.
see http://joemako.tumblr.com/post/3734611805/creating-a-worksheet-to-look-like-a-legend-and for another example that sorts based on the result of a table calc.
Yes that is what I am currently doing. I will try and get a mock up if I can't figure this out.
Thanks for the response when I tried what you are suggesting it separated my stacked bar chart that defeated my initial goal. But you helped me realize that I was only calculating one of the values that I wanted to have grouped.
First: created a second calculated field (All Others Percent) that calculated the other values.
Second: Created a third calculated field (RankStacked) that subtracted the first from the second (All Others Percent - HSG Percent)
Third: Put the third Calculated field where I had the rank and that gave me the sort and kept my stacked bar chart together.
So thank You for leading me to the solution.