1 of 1 people found this helpful
If I am understanding your requirements correctly, this might work for you. You need to go to "Edit Table Calculation":
Under Compute Using, select "Advanced." You'll need to address item, bill name and order number (in that order):
Finally, for "At the level:" select Item:
Gives you the following output:
Let me know if this helps or if I've misunderstood your requirements.
First Step- To get one rank per Item
right-click rank, Edit Table Calculation, compute using Advanced, bring Item, Bill Name and Order number in Addressing.
Compute at the level Item.
Next - To get the sorting
Right-click Item , select Sort , Sort By Field, select Price - Aggregation Sum
Finaly - To keep the sorting based on all the data and not only the data in the view, you need to filter the year using a table calculation.This will force Tableau to compute the sorting before filtering the date.
See in the attach (you will need to install a copy of 9.3 to open the workbook, two versions can be installed on the same PC)
Rank() problem (ed mc 9.3).twbx 29.5 KB
Awesome job Ben, thanks!
Hi Michel and thanks. I'll check this out when I get 9.3 installed.