4 Replies Latest reply on May 11, 2018 4:02 PM by g o

    Grouping Dimensions by Measure??

    g o

      Hi my fellow Tableau gurus - I need some help! I have a dataset similar to below where the ask is to group all Quantities of  <=2 to a group called 'OTHER'.

      So the end goal would look like Chart B.

       

      Currently my calculation looks like the below which says it's valid and it does what I want...

       

      IF SUM([Quantity])<=2 THEN 'OTHER'

      ELSE ATTR(Project)

      END

       

      However, I'm getting this error message when I try to sort.

       

      Invalid field formula due to limitations in the data source.

                                                                                                                                                      

      Unable to calculate the sort for the field 'AGG(Other)'. The display may not show correct data.

       

      Chart A

      ProjectQuantity

      A

      6
      B

      5

      C3
      D2
      E1

       

      Chart B

      ProjectQuantity

      A

      6
      B

      5

      C3
      OTHER3