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