7 Replies Latest reply on Aug 30, 2016 10:51 AM by David Li

# Simple Table Sort

I am having trouble sorting a table that is a section of one of my Dashboards.  Basically I would like to sort it in order of the count of occurrences verse alphabetic.

I have attached a workbook organized in a similar way.

Any thoughts?

• ###### 1. Re: Simple Table Sort

Hi Edward, how about this? I created a custom calculation that's just -SUM([Count]) and then forced it to be discrete so I could put it before the other dimensions. This basically forces the cells to sort in descending order by Count.

1 of 1 people found this helpful
• ###### 2. Re: Simple Table Sort

Thanks for the HELP!

I think we are getting closer however the sort really should be:

Fruit Punch - 10

Grape - 7

Orange – 6

Then sub-sort as:

Fruit Punch – Kool-Aid - 6

Fruit Punch – Fanta - 4

Grape – Fanta – 4

Grape – Koolaid - 3

Orange – Koolaid – 4

Orange – Fanta - 2

• ###### 3. Re: Simple Table Sort

To do this, we'll need a LOD calculation to sum up the counts first:

{FIXED [Flavor] : SUM([Count])}

Then we make that a dimension, put that as the first dimension in the sheet, and move the other sort farther back so we don't get repeated rows.

If this is the correct solution, please mark it as correct. Thanks!

1 of 1 people found this helpful
• ###### 4. Re: Simple Table Sort

I think that would do it!

So simple Tableau Question now..   How do I then hide the calculation columns?  (Meaning "Calculation2" and "Calculation1")

• ###### 5. Re: Simple Table Sort

There's no way to hide them from the rows shelf, but as you can see, they don't show up in the view itself. If you don't want them to show up anywhere on the screen, you can put the sheet into a dashboard.

1 of 1 people found this helpful
• ###### 6. Re: Simple Table Sort

David,

When I drop in these calculations they show in the worksheet.

Any thoughts on why it might be showing on my side and not on yours?

Ed

• ###### 7. Re: Simple Table Sort

Right-click the pills and uncheck "Show Header".

1 of 1 people found this helpful