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