Subscribe Bookmark RSS Feed

sum transactional data

Alexllorens

Occasional Contributor

Joined:

Oct 3, 2017

Hello, I'm trying to SUM the Quantity variable PER customerID. This is transactional data (sample below)

 

How to get that sum for each single customer when I have over 500K rows with 4K customers?

 

 

QuantitydummyInvoiceDateTotal PurchaseUnitPriceCustomerIDCountrydays since
111-Dec-1110-Dec-11505014911EIRE1
1211-Dec-1110-Dec-1117.41.4514911EIRE1
311-Dec-1110-Dec-1129.859.9514911EIRE1
1811-Dec-1110-Dec-1167.53.7514911EIRE1
411-Dec-1110-Dec-11174.2514911EIRE1
311-Dec-1110-Dec-1114.854.9514911EIRE1
611-Dec-1110-Dec-1117.72.9514911EIRE1
1211-Dec-1110-Dec-1110.20.8517489United Kingdom1
1211-Dec-1110-Dec-11151.2517489United Kingdom1
1211-Dec-1110-Dec-1119.81.6517489United Kingdom1
1211-Dec-1110-Dec-1124.962.0817489United Kingdom1
1211-Dec-1110-Dec-119.960.8317489United Kingdom1

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson

Super User

Joined:

Jun 22, 2012

Solution

You can either use 

     Tables==>Summary

To create a new data table with your sum calculated per Customer ID

or

You can use

     Analyze==>Tablulate 

To create a report of the sum for each Customer ID

or

You can create a new column in your data table and use the following formula to generate the sum for each customer ID

Col Sum(:Quantity, :Customer ID)
Jim
2 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

Solution

You can either use 

     Tables==>Summary

To create a new data table with your sum calculated per Customer ID

or

You can use

     Analyze==>Tablulate 

To create a report of the sum for each Customer ID

or

You can create a new column in your data table and use the following formula to generate the sum for each customer ID

Col Sum(:Quantity, :Customer ID)
Jim
Alexllorens

Occasional Contributor

Joined:

Oct 3, 2017

Thank you very much!