Date transformation, Summary at month level

[srk0609]

Hi, I have following input file and would like to get following 3 separate output files could you please help. I have attached the input file.and desired outputs below. Thank you so much.

output 1(sum of quantity, price for month)

Month/Year	Quantity	Price
01/2020	23	230
02/2020	23	230

output 2(cumulative sum of quantity, price)

Month/Year	Quantity	Price
01/2020	23	230
02/2020	46	460

output 3(by state)

State	Quantity	Price
washington	2	20
New jersey	2	20
New york	17	170
Texas	3	30
Maryland	10	100
Utah	5	50
Virginia	7	70

[DataNath · Accepted solution]

One way of achieving this @srk0609 - you would just need to replace the browse tools with Output Data tools of course!

[srk0609]

Thank you @DataNath