Limit the display of values

[#1]

Hello,

In a histogram, I want to show that the three smaller values without fixier maximum terminal.

Thank you in advance.

[#2]

Someone who can help me please ?

[MK_QSL]

Can you please explain little more about your requirements?

[#4]

go to the dimension limits and select the Restrict which the first values are displayed and select the show only smallest and give the values which you want to display on the chart....

[#5]

I want to have a flotop that displays the first 3 small values without putting a condition on these values.

[#6]

I want to have a flotop that displays the first 3 small values without putting a condition on these values.

[MK_QSL]

Consider that you have below table...

Sales:

Load * Inline

[

  Customer, Sales

  A, 100

  B, 90

  C, 125

  D, 45

  E, 30

  F, 130

];

You can get bottom three as below..

Create a Straight Table.. Dimension = Customer

Expression

SUM({<Customer = {"=Rank(-SUM(Sales),4)<=3"}>}Sales)

[#8]

Thank you very muche.

To say that i just want the first three  without specifying that less or equal to 3 ?

[MK_QSL]

Sales:

Load * Inline

[

  Customer, Sales

  A, 100

  B, 90

  C, 125

  D, 45

  E, 30

  F, 130

];

NoConcatenate

Sales2:

Load Customer, SUM(Sales) as TotalSales

Resident Sales Group By Customer;

NoConcatenate

Final:

First 3

Load

  Customer,

  TotalSales

Resident Sales2

Order By TotalSales Asc;

Drop Tables Sales, Sales2;

Now create a straight table with Customer as Dimension and SUM(Sales) as Expression...

[#10]

Thank you very much for your help.

It does not respond quite what i want but it helps me to another problem.