Execute the quartile formula in certain months

0

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?

    
asked by anonymous 28.09.2018 / 16:50

0 answers