Add subtotals for multiple column criteria

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

tEST INPUT Export.xlsx

Transformation

Accepted answers

atcodedog05

Hi @tiverson

Here is how you can do it.

Workflow:

Hope this helps : )

totals.yxmd

Christine_Assaad

Hi @tiverson

I built a solution using macros to get to this report

Subtotal WF.yxzp

atcodedog05

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/ba-p/779546

Hope this helps : )

All comments

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

tEST INPUT Export.xlsx

Christine_Assaad

Hi @tiverson

I built a solution using macros to get to this report

Subtotal WF.yxzp

tiverson

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

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

tEST INPUT Export.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703