I have a table with hundreds of values and these are divided between product name and date of sale.
I've filtered the type of product (in the example, blouses and shirts) and now I want to get the quartiles for each month.
Example
Nome Data Quantidade
Blusa 1 01/01/2018 2
Blusa 1 01/02/2018 1
Blusa 1 01/01/2018 5
Blusa 1 01/02/2018 10
Camisa 2 01/02/2018 6
Camisa 2 01/02/2018 2
Camisa 2 01/03/2018 8
I'm running this command
=AGREGAR(17;7;SE(MÊS(Tabela[Data])=1;Tabela[Quantidade]);0)
But it is not working. What could I do?