Sum Calculation from List A to List B

%3CLINGO-SUB%20id%3D%22lingo-sub-1658254%22%20slang%3D%22en-US%22%3ESum%20Calculation%20from%20List%20A%20to%20List%20B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1658254%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22kvgmc6g5%20cxmmr5t8%20oygrvhab%20hcukyx3x%20c1et5uql%20ii04i59q%22%3E%3CDIV%3EHi%20All%2C%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22o9v6fnle%20cxmmr5t8%20oygrvhab%20hcukyx3x%20c1et5uql%20ii04i59q%22%3E%3CDIV%3ECan%20anyone%20guide%20me%20on%20how%20to%20get%20the%20sum%20of%20Quantity%20for%20all%20quarters%20based%20on%20the%20product%3F%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22o9v6fnle%20cxmmr5t8%20oygrvhab%20hcukyx3x%20c1et5uql%20ii04i59q%22%3E%3CDIV%3E1%5D%20List%20A%20has%20complete%20data%3C%2FDIV%3E%3CDIV%3E2%5D%20List%20B%20has%20to%20be%20SUM%20of%20each%20fruit%20by%20quarterly.%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22o9v6fnle%20cxmmr5t8%20oygrvhab%20hcukyx3x%20c1et5uql%20ii04i59q%22%3E%3CDIV%3EAttached%20is%20the%20expected%20output%20data%20which%20I%20created%20in%20excel%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22o9v6fnle%20cxmmr5t8%20oygrvhab%20hcukyx3x%20c1et5uql%20ii04i59q%22%3E%3CDIV%3EBasically%20is%20used%20SUMIFS%20in%20excel.%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EVinod%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1660389%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20Calculation%20from%20List%20A%20to%20List%20B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1660389%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F790616%22%20target%3D%22_blank%22%3E%40vinodrocks300%3C%2FA%3E%26nbsp%3Bso%20why%20not%20just%20click%20on%20Export%20to%20Excel%20at%20the%20top%20of%20List%20A%20and%20do%20the%20quarterly%20totals%20there%3F%20Otherwise%20you%20are%20going%20to%20have%20a%20complex%20flow%20in%20Power%20Automate%20to%20handle%20the%20calculations.%20Sometimes%20-perhaps%20surprisngly%20-%20Excel%20is%20the%20right%20solution.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor
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

 

1 Reply
Highlighted

@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