How do I create a % formula between fields
Hi All, I have a data format like this Account Group Amount Acc1 Group1 200 Acc2 Group1 400 Acc3 Group1 100 Acc4 Group1 300 Acc1 Group2 150 Acc2 Group2 600 Acc3 Group2 200 Acc4 Group2 200 I want to calculate the share between accounts in the image below For Acc1 there is no need to do the calculation, for Acc2, Acc3... the calculation is always from Acc1. The calculation is like in the picture column % Help me for cases like this
