Thanks for your reply. Yes that is exactly what I'm trying to understand, how I can have tableau display the rank of the grand totals shown.
Really appreciate your insight, thanks, Simon
Sent from my iPhone
If you read the values given as part of the grand total you will see that the rank calculation you have included is not computing on the grand total - my problem is I don't understand what it is computing e.g. I would expect the product with the highest average grand total to be ranked number 1, which in this case should be Salesforce Portal with an score 6.665
If anyone can help this would be sincerely appreciated
Can anyone shed light on this? Many thanks,