Top 5

[#1]

i have data for sales and i m using server10.

i want to show sum of sales in chart but only top 5 sales.

Top 5 sales are changed regularly on the basis of sales.

i want to know how to show top 5 sales on bar chart on monthly basis.

[m_woolf]

You should search for your issue before posting.

[Anonymous]

sort them by there values and limit the no data points to be shown in presentation tab

[#4]

i need any micro or button by using that i will get top 5 values on charts .

there may be more than one chart and may be expression like sum(sales).

sum(visits) or sum(dl). and dimension also different.

[sivarajs]

create a variable like top,then create a input box with top variable

use the same variable in (maximum visible) presentation tab of chart properties e.g =top

If you enter values in input box it shows the charts accordingly

[#6]

Hi,

First create a variable eg. vTopX.

then Create a Input Box eg.TopN and use this variable in this Input Box.

After this In your charts, Sort the values on YAxis.

thn in the Presentation Tab chk(Tick) the "Max Visible Number (1-100)" in "Dimension Limitation" and put the Name of the Variable in the "Max Visible Number (1-100)" eg. =vTopX.

Also chk(tick) the option in Presentation tab "Show X Axis Scrollbar"