cancel
Showing results for 
Search instead for 
Did you mean: 

How to actually SUM

NiCd Battery
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?
Labels (1)
0 Kudos
2 Replies
DC Motor
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
Image: https://us.v-cdn.net/6030933/uploads/editor/ga/jyufliibdji9.png
Step 2: Compute a new column with any value - (In this case "Random") and create a lens of this view.
Image: https://us.v-cdn.net/6030933/uploads/editor/e8/6u4sb4un4csc.png

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
Image: https://us.v-cdn.net/6030933/uploads/editor/dt/00jrgkgcq4c1.png
Step 4: Perform a lookup to the "Look up View" created in Step 2 using the following connection options
Image: https://us.v-cdn.net/6030933/uploads/editor/oi/qcof1749x4ni.png
Image: https://us.v-cdn.net/6030933/uploads/editor/ja/wy9p57ddacfx.png
Step 5: Remove the undesired columns.
Image: https://us.v-cdn.net/6030933/uploads/editor/13/cz8uii329gn5.png

I hope this helps! 

Thank You,
Akshay

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