Subtotals for multiple criteria, removing repeated rows and display on multiple tabs

Question

I have attached a small data table that I need to summarize by division, by FX, by project name.

The unusual thing about this is when a project has a duplicated amount, but with a different PO.  I need to reduce the data to one line of detail, however list ALL PO's associated with the project.

Below you will see that the first project has multiple lines, however the last 2 have the same amount.  This is where I just need one line displayed with BOTH PO's listed (shown in output table below)

Data

Desired Output

For the final presentation, I want to sum by each project, by FX, then sum each page by Division.

I also need each division to be displayed on their own tab.

I hope I explained this well enough, thank you for your assistance in advanced!

Alteryx test data.xlsx

tiverson · Answer

Attached is what I have so far.

The biggest challenge I have is trying to remove duplicate amounts that have a PO listed

Jay FX sum.yxmd

TrevorS · Answer

Hello @tiverson

Thanks for posting to the Community!
Can you please provide a copy of your workflow and what you have attempted so far?

Our Community would be happy to assist you with any specific issues you are encountering!

If you have been able to resolve your request, please let the Community know how you went about your solution so you can get credit for the solution!
Thank you,
TrevorS