Thanks for the response. I'm actually looking for the rank to be the rows. I don't actually need the client in there at all.
2 of 2 people found this helpful
I've had a go as well:
I used the same calculated field for the rank as Don Wise, but edited the table calculation to:
(reached via the drop-down menu for the Rank pill, Edit Table calculation)
Note that Lilach Manheim (I hope I picked her correct profile!) created an excellent reference to the order of table calculations: Tableau Public I find this very helpful, even if I didn't use one of the examples in this case.
I then made Rank discrete, added it to rows (instead of client), made the mark type square and dragged a copy of SUM(sales) to colour.
Generally with regard to table calculation, it can get a bit mind-bending, but there's plenty of reference material out there. Also include the concepts of addressing and partitioning in your searches. I'm still not fully au fait with the concepts, so I have to look it up each time
Brilliant! Thank you for your help, this is exactly what I needed. And thanks for the link as well