giving value to max 5 value

[#1]

I am tring to give different values for max 5 row in straight table.

for example 1.max value=5,

------ 2.mav value=4,

------ 3.mav value=3,

------ 4.mav value=2,

------ 5.mav value=1

[its_anandrjs]

Hi,

Sort the expression in descending order sum(Amount) and set a variable and use it to display top max values

Like vMax = 0 and use this variable in input box and set a variable in chart properties Max Number -> check mark it -> and paste a variable there =vMax

See the atttached sample file and solution sheet.

Rgds

Anand

[SunilChauhan]

see the attached file

hope this you required

[#4]

I am tring to find max Amounts and give them these values

[its_anandrjs]

Hi,

You see my application

Rgds

Anand

[#6]

Name	CatID	sum(Amount)	value
		4748,59
Bill	3	1000	5
Chris	19	972,5	4
Jack	1	600	3
Chris	20	563,55	2
Chris	18	555	1
Bob	12	444
Bob	8	300
Jack	6	66
Bob	10	55
Bob	7	44
John	5	44
Bob	2	40
John	13	23
Jack	15	10
Bob	11	8
Chris	17	5,54
Bob	9	5
Jack	16	5
John	4	4
John	14	4

this is what I am tring to do

[its_anandrjs]

Hi,

I suggest if in place of this if you set a variable then use this varaible in the strainght chart to diaplay top 5, top 10, top 15 etc is a best parctice to show the data

See the attached Solution Sheet sample file.

Rgds

Anand

[vincent_ardiet]

Hi,

Try this expression : =6-if(rank(Total Amount)<=5,rank(Total Amount))

Regards,

Vincent

[its_anandrjs · Accepted solution]

Hi,

Use this code

if(isnull(6-if(rank(Total Amount)<=5,rank(Total Amount))) , ' ',6-if(rank(Total Amount)<=5,rank(Total Amount)))

As a rank of the table in second expression.

See the attched.

Rgds

Anand

[#10]

this is absolutely what I need thank you very much:))

can I calculate total amount with a set analysis