Groups By Dates By Month and Create Pivot Table in Excel

[BeratColak (Berat Çolak)]

Hi,

I have a question about creating a pivot table in Excel. There are 4 separate columns in Excel. There is a date in one of these columns. The data in columns A and B exist in more than one. I want to write columns A and B by months and sum the values in column C and show them in the pivot table.

How can I split the dates by months and sum and write based on the data in each column A?

Ağu = August
Eyl = September
Eki = Octomber
Kas = November
Ara = December

Malzeme and Satış Kodu are Ingredients ID
Özet Miktar is Amount

[BeratColak (Berat Çolak)]

Pivot Table:

[BeratColak (Berat Çolak)]

It was happening due to excel setting. I solved this problem!