BookmarkSubscribeRSS Feed
Alexllorens

Community Trekker

Joined:

Oct 3, 2017

sum transactional data

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
Highlighted
txnelson

Super User

Joined:

Jun 22, 2012

Solution

Re: sum transactional data

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
Highlighted
txnelson

Super User

Joined:

Jun 22, 2012

Solution

Re: sum transactional data

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

Community Trekker

Joined:

Oct 3, 2017

Re: sum transactional data

Thank you very much!