Chart Properties: Ranking Columns

[knightwriter]

Hi All,

Easy one I reckon but I actually cant find the answer!

I have a chart pivot table and I have used 2 Dimensions but I want to rank the chart by the highest expression Ive used (YTD Total).

How do I do this?

Im in Chart Properties -> Sort -> ??

Many thanks

[buzzy996]

try, from sort tab by selecting ur expression & expression check box.

else

else use dimensions limit.

[#3]

You don't need the Sort Tab. You need to look at the Dimension limits TAB and  check the restrict which values are displayed and then you can set your desired output.

Remember to uncheck Show others if you do not wish to show the values that do not belong to your setup.

quick view by default groups all the values that are out of your setup as one chunk and calls them others.

hope this helps.

[avinashelite]

try with the dimension limit or sort by DESC order on the expression..