I have a big old list of SKU codes along with the sales for the last fiscal year. For the sake of simplicity, let's say the SKU codes are in Table1[SKU] and the sales are in Table1[Sales].
How can I use the PERCENTILE function to figure out which SKUs make up the first 80%, 15% and the last 5%?
OR
Should I be using a different function?
How can I use the PERCENTILE function to figure out which SKUs make up the first 80%, 15% and the last 5%?
OR
Should I be using a different function?
