Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a chart in which I'm displaying names of salesmen and next to each one I'm displaying the count of invoices related to each salesman
what I want now is to display the rank of each salesman based on the number of invoices
I have the dimension set to the salesman code and in the third column the expression is rank(count(invoice))
what I'm getting in the rank column is numbers 1,2,4,... but these numbers are being repeated for other salesmen even if the number of invoices is different
Please help
ah No
I want to apply the ranking on the second dimension not all the dimensions
I used AGGR(rank(count(cardCode)); cardCode is the id of the invoice in my database
and I got what I want!!!
Please select this as correct answer!!!
I have taken some sample data and tried what u want.Try this else upload some sample data.
you example is helpful but I have 2 dimensions the first one is the group of salesmen and the second one is the salesmen code
I want to rank an expression based on the second dimension
hi,
then add the TOTAL qualifier to the rank() expression.
see picture
Pat.agen is right.
'Total' will work for u...
ah No
I want to apply the ranking on the second dimension not all the dimensions
I used AGGR(rank(count(cardCode)); cardCode is the id of the invoice in my database
and I got what I want!!!
Please select this as correct answer!!!