I want to change the data from row into to column and sum

[Sshasnk]

Hi I have dataset below where I have to group by class and sum the amount for each of the columns

Fund	Class	Amount	purchase	total net	sell
ABC	A	145	78	21	45
ABC	B	123	46	23	23
ABC	A	23	78	12	12
ABC	B	14	54	32	0

Ouput:

Fund	Description	A	B
ABC	Amount	168	137
ABC	Purchase	156	100
ABC	Difference	12	37
ABC	Total net	33	55
ABC	sell	57	23

Difference = amount - purchase

I sort of know it can be done with the cross tab tool but I am using cross tab for 4 times, is there any other better way to do it

[Felipe_Ribeir0]

Hi @Sshasnk 

One way of doing this

[binu_acs]

@Sshasnk Similar to @Felipe_Ribeir0 approach

[Felipe_Ribeir0]

Hi @Sshasnk 

It worked?