4 Replies Latest reply on Aug 3, 2012 6:24 AM by Peter Hopwood

    Plotting Top 10, Bottom 10 and Total results simultaneously

      I'm currently working with a set of data where I have Profit (measure) and the dimensions of Region and Division.

      My ideal would be to plot a graph which shows overall average total performance, the average performance of the top 10 performers and the average performance of the Bottom 10 performers.

       

      Can anyone suggest how to go about scripting this, as the Set 'top 10' function, is great at separating the top 10, but then leaves me unable to plot this simultaneously against the average for the rest of the population.

       

      Many thanks for all your help!