Filtering input sets for joining

[avincoff]

Currently, my workflow is only pulling the value of Sale 1 from my excel input file. Is there a way to create a filter to sum the 3 accounts prior to joining the mapping file with a larger data set? 

[Raj]

@avincoff yes this is achievable 
can you please add some sample input and expecred output
will help with flow

[avincoff]

Hi Raj, thanks for offering to help. I've attached a dummy excel file. 

I would expect the output to show just 1 column consisting of Sale then Cost followed by a second column next to it illustrating the Total Sale and Total Costs.

[Raj · Accepted solution]

@avincoff one way of doing this
mark done if solved.