Rank Total

[#1]

Hi all,

I am struggling with something seemingly simple! I need to return the maximum rank from a table. e.g. from the table below, I need to return 6 on every record.

Sales Amount	Rank
10	2
20	4
30	5
45	6
5	1
15	3

Any help greatly welcomed as my brain is not functioning properly today!

Regards

Haider

[swuehl]

It's not clear to me if Rank is a field or an expression in a chart object (with what dimensions)?

Maybe it's just like

=max(total Rank)

?

[#3]

Sorry, I should have been more clear. The column Rank in the table is calulcated based upon the Sales Amount in the first column and would have the following expression SUM([Sales Amount]). I need to calculate the maximum rank (6) and return it for each record. Hopefully that is more clear.

[#4 · Accepted solution]

Hi Haider,

I have a similar issue to swuehl so made an assumption.

See sample attached.

Kind Regards,

Footsie

[#5]

Perfect - many thanks. I was so close 😉