After sorting the view so that it is in the correct order, create a calculated field similar to the following:
index()<=10 or last()<=10
Then, place this on the filter shelf and select True. Only the top and bottom performers will appear. Hope this helps!
Thanks for your response, unfortunately I'm not sure it quite solves my problem.
I'm trying to simultaneously plot the aggregate of Top 10, Bottom 10 and Total Population.
Your approach would, I think, plot 20 lines (10 Top ones and 10 Bottom ones) seperately.
For example, with assuming a Top 1 and Bottom 1 variant, with 5 members of a group being
Assuming I was plotting Total values, I would want to plot Top 2 (10+5 = 15), Bottom 2 (1+ 2 = 3) and Population (sum = 21) at the same time.
Alternatively, with averages, I would be plotting Top 2 (7.5), Bottom 2 (1.5) and Population Avg (4.2)
In both cases I would want to plot a set of 3 points for each month over a 4 year period.
My question is therefore how to create a new plottable set with 3 values, being the Top x, Bottom x and Population total.
A similar way to look at this would be 'how would I plot the Median, Upper and Lower quartiles of a dataset on the same graph'.
Thanks Tracy, That worked for me :-)
If you are after the : '...Median, Upper and Lower quartiles of a dataset on the same graph'. could you use reference lines on a chart to achieve this - as you have the options of medians and quartiles with reference lines?