Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Haider,
I have a similar issue to swuehl so made an assumption.
See sample attached.
Kind Regards,
Footsie
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)
?
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.
Hi Haider,
I have a similar issue to swuehl so made an assumption.
See sample attached.
Kind Regards,
Footsie
Perfect - many thanks. I was so close 😉