data conversion

[former_member196948]

Hi to all

Actual data  in database

COUNTY	AID CODE	ACTIVE	TERMINATED	GRAND TOTAL
Alpine	84	52	4	56
Alpine	85	6	0	6
Amador	84	657	53	710
Amador	85	74	4	78
Amador	88	15	0	15
Amador	89	3	3	6
Butte	50	25	7	32
Butte	53	6	0	6
Butte	84	5195	618	5813
Butte	85	554	89	643
Butte	88	52	3	55
Butte	89	20	6	26

convert to.....

COUNTY	AID CODE	ACTIVE	TERMINATED	GRAND TOTAL
Alpine	84	52	4	56
Alpine	85	6	0	6
Total		58	4	62

Amador	84	657	53	710
Amador	85	74	4	78
Amador	88	15	0	15
Amador	89	3	3	6
Total		749	60	809

Butte	50	25	7	32
Butte	53	6	0	6
Butte	84	5195	618	5813
Butte	85	554	89	643
Butte		5252	723	6575
Butte	89	20	6	26
Total	5852	723	6575	6576

I am using 3.1

Thanks in advance

Ranjeet

[former_member225163 · Accepted solution]

>Apply break on country

>enable break footer and took sum of those active, terminated and grand total columns

Thanks,

Bala

[former_member196948 · Accepted solution]

thanks bala