5 Replies Latest reply on Nov 15, 2013 7:21 AM by Dallin Crump

    Complex query! (for a newbie)

    santhosh krishnan

      I am working with a set(attached). This is an exhaustive list - I need to pick the top 5 in terms of totals and calculate a percentage.

       

      For example Allergy total=540

      Table total =1404

      then Allergy% should be 38%

       

      Based on the above calculation I need to pick top 5 (I cant do this manually everytime - the top 5 automatically need to be picked)

       

      Once this is done, I need to replicate the attached chart (horizontal stacked bar chart)

       

      Remember now when we pick the top 5 , the 38% should REMAIN 38% and should not be higher percentage based on the sub-set (i.e top 5 items).