-
1. Re: Simple Table Sort
David Li Aug 30, 2016 8:01 AM (in response to Edward Peugh)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.
-
Test.twbx 18.2 KB
-
-
2. Re: Simple Table Sort
Edward Peugh Aug 30, 2016 8:15 AM (in response to David Li)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
David Li Aug 30, 2016 8:30 AM (in response to Edward Peugh)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!
-
Test.twbx 18.0 KB
-
-
4. Re: Simple Table Sort
Edward Peugh Aug 30, 2016 9:00 AM (in response to David Li)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
David Li Aug 30, 2016 9:01 AM (in response to Edward Peugh)1 of 1 people found this helpfulThere'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.
-
-
7. Re: Simple Table Sort
David Li Aug 30, 2016 10:51 AM (in response to Edward Peugh)1 of 1 people found this helpfulRight-click the pills and uncheck "Show Header".