Hello, I would appreciate your help for the below. I am trying to do the calculation of (A+E-I) in column Group_2 based on Group_1 and Date columns. The output should give me the result of (A+E-I) for each date in Date column based on Group_1 e.g. for the date 01/2018 for 1 (in Group_2). I Would appreciate if you can show me a way. Thanks a lot from now! Group_1DateGroup_2Group_31 01/2018 A884991991 02/2017 E204958411 02/2018 I735231582 03/2016 A39251542 03/2017 A1347887792 03/2018 E566570153 04/2016 I130150903 04/2017 A243463673 04/2018 A931579004 05/2016 A226103374 05/2016 E2964604 05/2016 I3843005 05/2017 A46356265 06/2016 A322371175 06/2016 I1647006 06/2017 A66380576 07/2016 A297199626 07/2016 E1647006 07/2016 I1823506 07/2017 A8344392

Calculation based on different colums

Hello,

I would appreciate your help for the below.

I am trying to do the calculation of (A+E-I) in column Group_2 based on Group_1 and Date columns. The output should give me the result of (A+E-I) for each date in Date column based on Group_1 e.g. for the date 01/2018 for 1 (in Group_2).

I Would appreciate if you can show me a way. Thanks a lot from now!

Group_1	Date	Group_2	Group_3
1	01/2018	A	88499199
1	02/2017	E	20495841
1	02/2018	I	73523158
2	03/2016	A	3925154
2	03/2017	A	134788779
2	03/2018	E	56657015
3	04/2016	I	13015090
3	04/2017	A	24346367
3	04/2018	A	93157900
4	05/2016	A	22610337
4	05/2016	E	296460
4	05/2016	I	384300
5	05/2017	A	4635626
5	06/2016	A	32237117
5	06/2016	I	164700
6	06/2017	A	6638057
6	07/2016	A	29719962
6	07/2016	E	164700
6	07/2016	I	182350
6	07/2017	A	8344392

Data Investigation

Accepted answers

BenMoss

Okay, it seems like the value in 'Group_2' is derived from the date field. So I would remove this from all the 'group bys' I mentioned, either in the cross-tab or summerize tool, depending on which method you use.