How to get column sum according to same column values?

[#1]

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

Date	Code	Qty	Total Qty
10-23-23	00	4	9
10-23-23	00	5	9
10-23-23	01	6	6
10-24-23	03	3	3
10-24-23	04	4	4
10-25-23	05	6	8
10-25-23	05	2	8

[#2]

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

[#3]

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