can you please send me .twb file itself without packing it.
Hi dinesh reddy,
To achieve above requirement, you have to create 2 columns in the sheet.
1) First create a Rank column and give "Rank(sum(sales))" in the field.
Now move the field the measure values and compute using City. Now it will rank the sales values by City.
2) Create other column as 'Display' and give "If [Rank]= 1 then 'Y' ELSE 'N' END" in the field.
Move this field into filter and select only 'Y'.
Now you will get only Rank 1 values which has Max sales by city.
Hope this help you .
Mark correct if its helped you.
Sever -- you took Dinesh's 9.0 workbook and saved it as a higher version. that's why he can't open it.
I've attached the twb, but it would be of use to you to install the latest version of Tableau Reader which would let you read all the packaged workbooks without having the latest version of Tableau.
Sorting v2.twb 268.0 KB