Below is my input
Input:
Fund | Purchase | sell | sum_purchase | sum_sell | difference1 | difference2 |
ABC | 10 | 5 | 7 | 3 | 5 | 4 |
We can remove the below formula and add it after the transposition as well
Difference1 = Purchase - Sell
Difference2 = Sum_purchase - sum_sell
Output:
Fund | Value | Value2 | |
ABC | Purchase | 10 | 7 |
ABC | sell | 5 | 3 |
ABC | Difference | 5 | 4 |
Solved! Go to Solution.
Hi @Sshasnk ,
I believe this is what you want to achieve :-),
Let me know if it works for you,
greetings,
Seb