3 Replies Latest reply on Jun 23, 2017 4:50 AM by Rahul Singh

    Top 80% of Dimension Values

    Jayson Osmars

      Hi.

       

      New to Tableau.

       

      I'm needing to filter a table of a dimension to the top 80% product performers.

       

      Such as a column of [UPC]'s and need to filter based on the top 80% of [Profits].

       

      I've been trying various calculations, if statements etc but I am just pounding into a wall.  Need to aggregate, can't use aggregation in an if etc etc.

       

      Anyone have an idea to help guide me to find a solution? 

       

       

      Much thanks.