Hi,
I need to be able to use an equation to identify the top/bottom 10% by month and year. I need an equation that looks at raw data and goes ok here are all the pieces for Feb FY18 of these 100 cells here are the 80 that you should count.
Every month will have a different top/bottom 10%.
For example, in April FY18, there are 37 lines. Rounding up i need to identify the top/bottom 4 lines.
My goal is to be able to do a month over month pivot, averaging category 1, and filtering out the top/bottom 10%
Thanks!
Bookmarks