tabulation between records

Discussions about tabulating data in the designer or in batch mode
atr
Posts: 19
Joined: August 25th, 2014, 7:03 pm

tabulation between records

Postby atr » August 28th, 2017, 12:17 am

Dear Users,

I have a variable in a Person record that captures each persons income. I want to tabulate household income by summing all these individual income for each household and show the average household income by region.

Grateful for any assistance.

Gregory Martin
Posts: 852
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: tabulation between records

Postby Gregory Martin » August 28th, 2017, 7:04 am

You can do this by creating a new variable in your working storage dictionary and then using table logic to fill that variable in with the sum of the individual incomes. See more here:

http://www.csprousers.org/help/CSPro/ta ... logic.html

atr
Posts: 19
Joined: August 25th, 2014, 7:03 pm

Re: tabulation between records

Postby atr » August 28th, 2017, 6:43 pm

Thanks Greg.... much appreciated.


Return to “Tabulation”