Sum by using formula

[Kinetic_analytics]

Hello:

Good morning. Is there any way to sum the column total in the bottom.

Product	Price
A	10
B	20
C	30
C	40
Total	100

How can I do this sum without Summarize tool?

Appreciate your help. 

Thanks

[PhilipMannering]

The Formula Tool can only work within a row - so you cannot sum multiple records with the Formula Tool unless you use the Cross Tab Tool first. Alternatively the Multi-Row Tool or Running Sum Tool could be used to arrive at the 100 Total. But Summarize Tool is how most people would do it and then union back on to their original data set. Let me know if any follow up questions!

[binuacs · Accepted solution]

@Kinetic_analytics One way of doing this

[Kinetic_analytics]

Thank you.