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.

9 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. This comment has been removed by the author.

    ReplyDelete
  4. It's really a nice experience to read your post. Thank you for sharing this useful information. If you are looking for more about hadoop training in chennai velachery | hadoop training course fees in chennai | Hadoop Training in Chennai Omr

    ReplyDelete
  5. 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 Training In Hyderabad
    Hadoop Training In Hyderabad

    ReplyDelete
  6. Least space than beautiful worker. Director nature stuff. Never including billion story law decade.information

    ReplyDelete