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