9 Replies Latest reply: Jul 28, 2014 8:02 AM by eddine eddine

# Limit the display of values

Hello,

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

• ###### Re: Limit the display of values

Someone who can help me please ?

• ###### Re: Limit the display of values

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

• ###### Re: Limit the display of values

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....

• ###### Re: Limit the display of values

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

• ###### Re: Limit the display of values

Consider that you have below table...

Sales:

[

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)

• ###### Re: Limit the display of values

Thank you very muche.

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

• ###### Re: Limit the display of values

Sales:

[

Customer, Sales

A, 100

B, 90

C, 125

D, 45

E, 30

F, 130

];

NoConcatenate

Sales2:

Resident Sales Group By Customer;

NoConcatenate

Final:

First 3

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...

• ###### Re: Limit the display of values

Thank you very much for your help.

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