Finding a specific row number after sorting

[#1]

I have a table with the following columns, Product class, Stock Code Number, Sales Order Number, Transaction Date and Gross Margin. There are 40 different Product Classes

We want to see, by Product Class, what is the Gross Margin at 5% of the line items and 10% of the line items, with Gross Margin sorted from worst to best. So, for example, if Product Class X has 100 total lines I want to first sort the list from worst to best Gross Margin and report what the margin is at line 5 (5% times 100 lines) and line 10 (10% times 100 lines).

Any ideas?

Thanks,

Stephen

[#2]

Hi,

Just use as expression

=fractile(GrossMargin , 0.05) for the5% line
=fractile(GrossMargin , 0.01) for the 10% line

with Product Class as dimension

JJ

[#3]

This returns nothing.