4 Replies Latest reply on Jan 22, 2015 8:49 PM by Tableau kumar

    Filter to show industries representing 95% of total output

      Dear all,

       

      Seems like this should be straightforward to find a solution to, but I have so far had no luck.

       

      To find material industries, I am looking to create a filter that shows all industries that together represent 95% of total output. Think 80/20 rule analysis.

      I have tried to create a calculated field to show output % of total and then filter by that, but have had no luck since [output]/sum([output]) is not accepted. How would you create a percentage of total field?

       

      Thank you for your help.

       

      All the best,

      Chris