3 Replies Latest reply: Jan 21, 2011 8:11 PM by Chakravarthy MS RSS

Top 5 in Bar Chart

Hi,

In the stacked Bar Chart for each dimension i have to display the top 5 values and remaining values as others.

For e.g if i have the country as dimension , i should display the top 5 cities and remaining cities sum in the stacked bar chart. It will have have 6 stacks with top 5 and others.

Any idea on this ?????

  • Top 5 in Bar Chart

    Hi XXX,

    You can restrict the Max Visible No(1-100) to 5 and can use the show others option (Enable the check box for others). But you have to use more than one dimension . Please share the data so that I can try it on...

    Regards,

    Chakravarthy.

  • Top 5 in Bar Chart

    Hi Chakravarthy,

    yes as u suggested we can display only 5 with sorting as descending. But it should have the others option and it should be stacked chart. Stacked is based on the multiple expression and the i am not sure it is based on dimension