Can you perform SUM over partitions with the Summarize tool?

[dbaluv]

I am converting a SQL script into an Alteryx Workflow. Newish to the tool.

How do you convert this 

sum(FY_19_sales_amount) over (partition by branch_name) branch_FY_19_sales_amount

Into an Alteryx flow?

Thanks.

[AbhilashR]

You could use a Summarize tool and have the following setup:

[dbaluv]

Thanks. That’s what I ended up doing. What if you have more than one calculation, should stack them up or use one summarize tool per calculation?

[AbhilashR · Accepted solution]

It depends on how you are looking to compute your values. If you use one Summarize tool which sum's up the numerical value across multiple dimensions (i.e. all dimensions set to GROUP BY), then Alteryx will show you the sum at the lowest granularity across the two dimensions.

If you are looking to compute the sum across each dimension separately, then using two Summarize tools would be the way to go.