Groups with Criteria

tableaucommunity@tableau.com — Wed, 26 Feb 2014 05:10:36 GMT

Hi, I am facing some problems with regards to grouping

Overview:

There are 5 brands coming under a manufacturer.

Eg: Manufacturer

Brand 1 40

Brand 2 60

Brand 3 150

Brand 4 10

Brand 5 10

Criteria:

All the brands which are less then 20 should be grouped and named as 'Others'.

The brands needs to be sorted on descending order where 'Others' should always be at the end no matter what.

The output should look like

Manufacturer

Brand 3 150

Brand 2 60

Brand 1 40

Others 20

Content in Tableau Community Forums