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).