"Percentage" of "Running Total" in "Sum"
from Pivot Table?
Hello,
From the below table , I have already added a Running Total of values (Col 1, Col 2 & Col 3)
Now, I would like add another columns next to each Columns with the percentage of those Running Totals respective to the last column (Total of Col 1 + 2 + 3).
Please let me know how can I get this.
Thanks in advance.
Month&Year of Date of Purchase
|
Col 1
|
|
Col 2
|
|
Col 3
|
|
Col 1 + 2 + 3
|
Feb 2016
|
Rs.0.00
|
0%
|
Rs.0.00
|
0%
|
Rs.13,880.18
|
100%
|
13,880.18
|
Apr 2016
|
Rs.0.00
|
0%
|
Rs.0.00
|
0%
|
Rs.21,198.74
|
100%
|
21,198.74
|
Jul 2016
|
Rs.0.00
|
0%
|
Rs.0.00
|
0%
|
Rs.39,887.59
|
100%
|
39,887.59
|
Oct 2016
|
Rs.0.00
|
0%
|
Rs.0.00
|
0%
|
Rs.56,032.27
|
100%
|
56,032.27
|
Nov 2016
|
Rs.0.00
|
0%
|
Rs.83,541.93
|
32%
|
Rs.180,732.56
|
68%
|
264,274.49
|
Dec 2016
|
Rs.0.00
|
0%
|
Rs.83,541.93
|
23%
|
Rs.283,696.12
|
77%
|
367,238.05
|
Jan 2017
|
Rs.0.00
|
0%
|
Rs.83,541.93
|
19%
|
Rs.351,887.86
|
81%
|
435,429.79
|
Feb 2017
|
Rs.0.00
|
0%
|
Rs.83,541.93
|
15%
|
Rs.467,990.06
|
85%
|
551,531.99
|
Mar 2017
|
Rs.0.00
|
0%
|
Rs.83,541.93
|
10%
|
Rs.718,997.84
|
90%
|
802,539.77
|
Apr 2017
|
Rs.0.00
|
0%
|
Rs.147,747.66
|
16%
|
Rs.777,651.90
|
84%
|
925,399.56
|
May 2017
|
Rs.0.00
|
0%
|
Rs.163,575.69
|
12%
|
Rs.1,155,521.77
|
88%
|
1,319,097.46
|
Jun 2017
|
Rs.0.00
|
0%
|
Rs.163,575.69
|
10%
|
Rs.1,557,560.36
|
90%
|
1,721,136.05
|
Jul 2017
|
Rs.0.00
|
0%
|
Rs.255,085.64
|
13%
|
Rs.1,688,707.07
|
87%
|
1,943,792.71
|
Oct 2017
|
Rs.22,236.87
|
1%
|
Rs.255,085.64
|
13%
|
Rs.1,688,707.07
|
86%
|
1,966,029.58
|
Nov 2017
|
Rs.22,236.87
|
1%
|
Rs.283,830.26
|
13%
|
Rs.1,946,850.85
|
86%
|
2,252,917.98
|
Jan 2018
|
Rs.22,236.87
|
1%
|
Rs.283,830.26
|
12%
|
Rs.2,036,736.37
|
87%
|
2,342,803.50
|
Feb 2018
|
Rs.22,236.87
|
1%
|
Rs.283,830.26
|
12%
|
Rs.2,062,219.68
|
87%
|
2,368,286.81
|