Sum Calculation from List A to List B

[vinodrocks300]

Hi All,

Can anyone guide me on how to get the sum of Quantity for all quarters based on the product?

1] List A has complete data

2] List B has to be SUM of each fruit by quarterly.

Attached is the expected output data which I created in excel

Basically is used SUMIFS in excel.

Regards,

Vinod

[#2]

@vinodrocks300 so why not just click on Export to Excel at the top of List A and do the quarterly totals there? Otherwise you are going to have a complex flow in Power Automate to handle the calculations. Sometimes -perhaps surprisngly - Excel is the right solution. 

Rob
Los Gallardos
Microsoft Power Automate Community Super User