How to get column sum according to same column values?

Question

Hi all

How to calculate the Total Qty if they have the same code? I am currently using Col Sum(:Qty) but it is getting the sum of all column values. I just want the sum of values with the same code & date

DateCodeQtyTotal Qty10-23-23004910-23-23005910-23-23016610-24-23033310-24-23044410-25-23056810-25-230528

txnelson · Answer

Here is the Scripting Index description of the Col Sum()

Note that the function allows for By Variables. Example 4 from the same Scripting Index entry, illustrates the use of the By variables with columns Age and Sex specified as By variables

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << New Column( "Sum for Each Age and Sex Group",
	Formula( Col Sum( :height, :age, :sex ) )
);

With the results

Stuart_Little · Answer

You can add the Code column as a grouping variable to achieve this - The required formula is:

Col Sum (Qty , Code)

I've put this in the attached table to illustrate.

Hope that helps,

Stuart

Group By Table.jmp