Hey Alteryx Community, I'm having a bit of an issue at the moment that you might be able to help me with. Essentially I've summarised by data to get this new dataset below: But i'm unsure as to how I can add the values in the Total for January and December for each ID together to get a grand total for each ID. IdentifierCompanyNameMonthTotalABC202_ATest Company 1 LimitedJanuary8102.16ABC202_ATest Company 1 LimitedDecember12352.89DEF100_BTest Company 2 LimitedJanuary756.25DEF100_BTest Company 2 LimitedDecember1014.75GHI987_CTest Company 3 LimitedJanuary3677.19GHI987_CTest Company 3 LimitedDecember3737.97 Any and all help is much appreciated I'm probably missing something on my end that I can seem to figure it out.

Adding values for a balance

Hey Alteryx Community,

I'm having a bit of an issue at the moment that you might be able to help me with. Essentially I've summarised by data to get this new dataset below:

But i'm unsure as to how I can add the values in the Total for January and December for each ID together to get a grand total for each ID.

Identifier	CompanyName	Month	Total
ABC202_A	Test Company 1 Limited	January	8102.16
ABC202_A	Test Company 1 Limited	December	12352.89
DEF100_B	Test Company 2 Limited	January	756.25
DEF100_B	Test Company 2 Limited	December	1014.75
GHI987_C	Test Company 3 Limited	January	3677.19
GHI987_C	Test Company 3 Limited	December	3737.97

Any and all help is much appreciated I'm probably missing something on my end that I can seem to figure it out.

Workflow

Help

Accepted answers

DataNath

Hey @Deano478 you could just further Summarize these values in a separate branch and then add them back to each relevant ID:

Add Jan+Dec Totals.yxmd

binu_acs

@Deano478 One way of doing this

Grand Total_1215.yxmd

ShankerV

Hi @Deano478

You can have the output in the below format also.

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

All comments

DataNath

Hey @Deano478 you could just further Summarize these values in a separate branch and then add them back to each relevant ID:

Add Jan+Dec Totals.yxmd

ShankerV

hi @Deano478

One way of doing this!!!

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

binu_acs

@Deano478 One way of doing this

Grand Total_1215.yxmd

ShankerV

@Deano478

Step 1: Input

Step 2: Summarize tool

Step 3: Join tool

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

ShankerV

Hi @Deano478

You can have the output in the below format also.

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

Deano478

@DataNath @ShankerV @binu_acs WOW I appreciate the rapid responses from all of you it's much appreciated I'll give these solutions a try now so I can understand them before implementing them and if I do have any further question about these solutions i'll let you know