Conditional Summing

Question

Hi everyone,

I am working on a flow that mimics a pivot table and organizes totals by the month (see 1,2,3,4,etc. and then total for the year).

I am wondering if there is a way to get my results to sum based off the columns being similar. In my screen shot (Alteryx Example) you can see that the there are "Ref" columns that have the same Man. Cntry Code and Product Line. If those two are the same I'd like them to Sum and give me the results in the screenshot "Alteryx Example Results". If either of those columns are different, then they don't SUM and these remain their own row.... hence the example with FR_Victory_Shipping where there are two different Man. Cntry Codes

Alteryx Example.png

Alteryx Example Results.png

Workflow example.png

CoG · Answer

@Raj- is exactly right!

Here is a sample workflow that uses some similar data to what you included in your images (in the future it is very helpful to include the input data as a spreadsheet attachment or table in your post):

Sample Workflow.yxmd

Raj · Answer

I suggest adding a summarize tool prior to Transpose tool selecting the required variable to Group by so this will push the required result.

if this do not help share a workflow with sample data i will help to debug.