How to actually SUM

[JRood]

Hi again, everybody.  So on my continuing work with this monster project (translating Data pulling/prep from an SPSS stream into Paxata to make ready for reporting) there's a step where I need to present the sum of several columns.  The thing is that using the SUM compute function just creates a new column with the same values as the one I want to SUM rather than giving me the SUM.  I've tried using Shaping and that gives several rows of SUM rather than just the overall SUM.

How can I take Column A and get the SUM of all values in that column as a new Column B that's the total overall sum of everything in A in one row?

[Akshay1 · Accepted solution]

Hello JRood,

In order to get the Sum of all the values in a single column, Please follow the steps mentioned below:

Step 1 : Load the desired Dataset

Step 2: Compute a new column with any value - (In this case "Random") and create a lens of this view.


Step 3: Use the group by function, to group by column test and perform the aggregate function on Column A to get the sum of all values in Column A

Step 4: Perform a lookup to the "Look up View" created in Step 2 using the following connection options


Step 5: Remove the undesired columns.


I hope this helps! 

Thank You,
Akshay

 

[JRood]

Hi Akshay.  Thanks for the steps!  It did create the right sort of effect and I really appreciate the visual aids.