Sum of Total

[apthansh]

Hi - I  have data as below..

Period        ID       Amount

p1                 1           100 

p1                2            500

p2                1             800

p2                2              100

I want to get the sum of Total amount by each period and the get the %.

Ex: For P1 ID 1 Should divide 100/600 and P2  ID1 should divide 800/900.

Any help/guide is highly appreciated.Thank you.

[apthansh]

I am trying to achieve Sum of Total Column  and % of amt column from the below example.

Period	ID	Amount	Sun Of Total	% of amt to total
p1	1	100	600	16.00%
p2	1	800	900	88%
p1	2	500	600	83%
p2	2	100	900	11%

[jonathandienst · Accepted solution]

Total by period is:

Sum(TOTAL <Period> Amount)

So, the % is

Sum(Amount) / Sum(TOTAL <Period> Amount)

formatted as %

[apthansh]

Awesome.Thank you much !