Adding values for a balance

[Deano478]

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. 

[DataNath · Accepted solution]

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

[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

[binuacs · Accepted solution]

@Deano478 One way of doing this

[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 · Accepted solution]

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 @binuacs 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  

[ShankerV]

Hi @Deano478 

Step 1: Input

Step 2: Summarize tool

Step 3: Union tool

Step 4:Formula tool

if IsNull([Month])
then "Grand total"
else [Month]
endif

Step 5: Sort tool

Output:

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