This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to figure out how to assign quartiles based on different key metrics and including criteria. In the example below, I want to be able to assign quartiles for the different products but only include products in that same department in the calculation. For example, what quartile do Apples fall into within produce for sales and then for profit. Output would be three new columns that list each product's quartile (1, 2, 3, or 4) for each metric, as shown in the blank columns. Can anyone please assist?