Help us build a better product, earn the PaxPro Advocate badge: Six short questions, one cool badge. 
Visit the official Paxata Documentation portal for all of your doc needs.
How to actually SUM
JRood
Posts: 10 ✭
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?
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?
Tagged:
0
Best Answer

Akshay Posts: 94 adminHello 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
5
Answers