Hi Nageswara Rao,
It is because you are using two dimension in the view, with one dimension sorting will work fine whenever you bring the second dimension granularity getting increase based on the sorting more than one dimension is a issue in tableau.
In order to solve this use the techniques either combined field or rank, go through the below url to understand more and how to resolve it
Mark this question as helpful/correct if it solves the issue so that it will be helpful to others
We've two Dimensions in the view Segment and Product Name. Sorting will work fine with one dimension.
We need to do use some tricks for Nested Sorting. Check the below link:
In your view, the sorting is based on product name for all the segments (sum the sales of product name for all segments), not for single segment. To sort product name in each segment, you need to:
Make a combined field (right select both segment and product name, select combined fields), and put it in the rows between segment and product name, and uncheck "show header", you will get it.
Hope it helps.
com.twbx 1.1 MB