Add subtotals for multiple column criteria

[tiverson]

I am trying to sum and format my data using multiple criteria.  

Data

Desired output:

I want to be able to sort the data by Division, FX, ARE and project name.  Once sorted, I want to sum the TX amount column by each change in FX, by division with a grand total for division under the FX totals

[atcodedog05]

Hi @tiverson 

The attached input file seems to be different can you please provide the correct input file.

[tiverson]

The first tab is the data and the second tab is the desired output

[atcodedog05 · Accepted solution]

Hi @tiverson 

Here is how you can do it.

Workflow:

Hope this helps : )

[christine_assaad · Accepted solution]

Hi @tiverson 

I built a solution using macros to get to this report

[tiverson]

My version of Alteryx will not let me download this solution.  

[atcodedog05 · Accepted solution]

Hi @tiverson 

No worries my friend follow this guide to downgrade the packaged workflow.

https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/...

Hope this helps : )

[tiverson]

I have one additional thing I need to filter for.  If a Project has a multiple PO's listed with similar amounts, I only need the amount listed once. 

I have attached the file that shows the desired output

[tiverson]

This solution works great.

To add to this workflow, how would I add a space and subtotal for each project also?