Example – Sorting a Hierarchy

This example uses a multidimensional data source to sort the rows of a bar chart in order to determine which beverages have the highest sales. To create the view, follow the steps below.
  1. Place the Sales measure on the Columns shelf and the Gen2,Product dimension on the Rows shelf.
    Drill down one level in the hierarchy to display Gen3,Product.

  2. Sort Gen3,Product in descending order by the Sales measure.
    Right-click on Gen3,Product and select Sort from the field’s context menu. In the Sort dialog box, select Descending as the Sort order and sort by the Sales field.

    The view is shown below. Notice that the Gen3,Product members are sorted within each parent member. For example, Cola, Diet Cola, and Caffeine Free Cola are sorted only within the Colas level. Tableau does not rearrange headers that appear before the sorted field.

  3. If you want to order dimension members without regard to its parent, you should remove Gen2,Product from the Rows shelf. The sorted data are shown below.

4 comments:

  1. How to drill down a hierarchy by clicking on pane in tableau?

    ReplyDelete
  2. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…



    Tableau Online Training|
    R Programming Online Training|
    SAS Online Training |

    ReplyDelete

  3. the blog is about Another Step in Tableau's Evolution? it is useful for students and tableau Developers for more updates on Tableau follow the link

    tableau online training hyderabad



    For more info on other technologies go with below links

    Python Online Training


    ServiceNow Online Training

    mulesoft Online Training

    ReplyDelete