Group Total in New Column

[JennyRuns24]

Hello,

Could someone assist me in adding a new column that displays a location total? For example, if the total for the group is 57, the number 57 will appear seven times in the new column.

Thank you

[JosephSerpis · Accepted solution]

HI @JennyRuns24 you can use a summarise tool to group by location and then sum the total and then use a join tool to join those total back onto your data using the location to achieve the results you describe.

[ShankerV]

@JennyRuns24 

Can you please attach a dataset or sample dataset, so that can work on the solution which best suites your need.

Many thanks

Shanker V

[PanPP]

Hi @JennyRuns24 

You will need to use the summarize tool in the Transform category of Designer.

In the summarize tool, group by the columns Campus Name / Client property code and then sum the last column.

Hope this helps, if it does please like this post and if it helps resolve your problem, mark it as a solution. If you have any other questions, please let us know.

[JennyRuns24]

Hello,

Thank you for your help...I still will need to show the BOMA 2nd level column, as well as, the sum boma column. Basically, I still need to show all columns in the image, but an additional one added. 

[PanPP]

You can then use the Join tool using the Campus Name as the unique identifier to merge the dataset back together giving you an extra column with the count value. 

Hope this helps, if it does please like this post and if it helps resolve your problem, mark it as a solution. If you have any other questions, please let us know.

[KrishnaChithrathil]

@JennyRuns24 

Will this help?

What do you mean by "Basically, I still need to show all columns in the image, but an additional one added."

If you need the original 'Sum_BOMA Weighted Square Footage......' you can check that particular column in Join tool configuration.

you'll get it like this.

[JennyRuns24]

Thank you for all of the details! Very helpful, Thanks!