Show Bottom 5 in Bar Chart??

[#1]

Hi Friends,

I want to show bottom 5 values in Bar chart .This is sample data and logic.

F1	F2
100	f
90	a
85	o
80	e
75	j
70	g
65	c
60	b
55	i
50	h
45	l
40	d
35	m
30	k
15	n

I need to show bottom 5 values based on the condition that first  I should arrange the data in descending order and after that I need to check 75% of the sum(F1). in this case it is 671.  So I will consider only those (First) valuse whose sum is 671. Exclude all other values. So my result set will be

100	f
90	a
85	o
80	e
75	j
70	g
65	c
60	b
55	i

I need to show bottom 5 rom this result set in the Bar chart

75	j
70	g
65	c
60	b
55	i

Thanks in advance.

[Clever_Anjos]

Use Dimension Limits Tab

[#3]

Hi divya,

first sort the loading order in reverse like

and next use the

[#4]

Hi,

When I show smallest 5 it shows

45	l
40	d
35	m
30	k
15	n

But I need to show

75	j
70	g
65	c
60	b
55	i

[tresesco]

Try expression something like:

Aggr(If(Rank(-Sum({<F2={"=Sum(F1)>Fractile(total F1,0.25)"}>}F1))<=5, Sum({<F2={"=Sum(F1)>Fractile(total F1,0.25)"}>}F1)), F2)