Forum Discussion
Calculating growth & Rearranging data lables
I have monthly data from April 14 to June 16 in this format (assuming only 2 customers) I want to compare the revenue from the first and last month and display the growth in percentage. ...
Hi shrmehta,
Would it be available for you to share the data in a Table format?
I only need ten rows of the data sample which could represent your data structure. I am not able to figure out the data in your uploaded image, as the items in the image are clouding.
Regards
Hi v-micsh-msft
Including the entire table
| Month | FY | Quarter | Customer Group Name | USD |
| Apr-14 | FY 15 | Q 1 | A | 24,959.06 |
| Apr-14 | FY 15 | Q 1 | B | 12,208.07 |
| Apr-14 | FY 15 | Q 1 | C | 617,797.88 |
| Apr-14 | FY 15 | Q 1 | D | 19,722.69 |
| Apr-14 | FY 15 | Q 1 | E | 9,438.53 |
| Apr-14 | FY 15 | Q 1 | F | 17,394.75 |
| Apr-14 | FY 15 | Q 1 | G | 746,503.10 |
| May-14 | FY 15 | Q 1 | A | 666,325.72 |
| May-14 | FY 15 | Q 1 | B | 633,191.13 |
| May-14 | FY 15 | Q 1 | C | 68,692.46 |
| May-14 | FY 15 | Q 1 | D | 24,959.06 |
| May-14 | FY 15 | Q 1 | E | 16,249.50 |
| May-14 | FY 15 | Q 1 | F | 13,841.54 |
| May-14 | FY 15 | Q 1 | G | 12,614.67 |
| Jun-14 | FY 15 | Q 1 | A | 683,747.14 |
| Jun-14 | FY 15 | Q 1 | B | 670,715.35 |
| Jun-14 | FY 15 | Q 1 | C | 68,420.27 |
| Jun-14 | FY 15 | Q 1 | D | 31,334.72 |
| Jun-14 | FY 15 | Q 1 | E | 24,959.06 |
| Jun-14 | FY 15 | Q 1 | F | 14,883.75 |
| Jun-14 | FY 15 | Q 1 | G | 13,814.15 |
| Jul-14 | FY 15 | Q 2 | A | 683,757.66 |
| Jul-14 | FY 15 | Q 2 | B | 588,355.13 |
| Jul-14 | FY 15 | Q 2 | C | 71,060.72 |
| Jul-14 | FY 15 | Q 2 | D | 67,943.27 |
| Jul-14 | FY 15 | Q 2 | E | 39,225.95 |
| Jul-14 | FY 15 | Q 2 | F | 30,183.77 |
| Jul-14 | FY 15 | Q 2 | G | 13,495.87 |
| Aug-14 | FY 15 | Q 2 | A | 683,747.03 |
| Aug-14 | FY 15 | Q 2 | B | 640,403.00 |
| Aug-14 | FY 15 | Q 2 | C | 67,032.10 |
| Aug-14 | FY 15 | Q 2 | D | 62,497.81 |
| Aug-14 | FY 15 | Q 2 | E | 42,950.00 |
| Aug-14 | FY 15 | Q 2 | F | 17,089.78 |
| Aug-14 | FY 15 | Q 2 | G | 13,367.00 |
| Sep-14 | FY 15 | Q 2 | A | 689,211.15 |
| Sep-14 | FY 15 | Q 2 | B | 651,497.33 |
| Sep-14 | FY 15 | Q 2 | C | 103,322.11 |
| Sep-14 | FY 15 | Q 2 | D | 67,128.44 |
| Sep-14 | FY 15 | Q 2 | E | 42,650.00 |
| Sep-14 | FY 15 | Q 2 | F | 19,221.75 |
| Sep-14 | FY 15 | Q 2 | G | 13,334.02 |
| Oct-14 | FY 15 | Q 3 | A | 685,930.36 |
| Oct-14 | FY 15 | Q 3 | B | 648,580.70 |
| Oct-14 | FY 15 | Q 3 | C | 398,016.14 |
| Oct-14 | FY 15 | Q 3 | D | 66,453.37 |
| Oct-14 | FY 15 | Q 3 | E | 63,845.75 |
| Oct-14 | FY 15 | Q 3 | F | 42,650.00 |
| Oct-14 | FY 15 | Q 3 | G | 15,355.23 |
| Nov-14 | FY 15 | Q 3 | A | 685,882.18 |
| Nov-14 | FY 15 | Q 3 | B | 630,634.31 |
| Nov-14 | FY 15 | Q 3 | C | 579,056.88 |
| Nov-14 | FY 15 | Q 3 | D | 99,046.94 |
| Nov-14 | FY 15 | Q 3 | E | 66,195.41 |
| Nov-14 | FY 15 | Q 3 | F | 42,650.00 |
| Nov-14 | FY 15 | Q 3 | G | 18,112.00 |
| Dec-14 | FY 15 | Q 3 | A | 685,859.90 |
| Dec-14 | FY 15 | Q 3 | B | 628,403.73 |
| Dec-14 | FY 15 | Q 3 | C | 555,977.91 |
| Dec-14 | FY 15 | Q 3 | D | 88,698.08 |
| Dec-14 | FY 15 | Q 3 | E | 72,903.52 |
| Dec-14 | FY 15 | Q 3 | F | 39,400.28 |
| Dec-14 | FY 15 | Q 3 | G | 14,437.80 |
| Jan-15 | FY 15 | Q 4 | A | 682,857.90 |
| Jan-15 | FY 15 | Q 4 | B | 583,480.04 |
| Jan-15 | FY 15 | Q 4 | C | 347,321.12 |
| Jan-15 | FY 15 | Q 4 | D | 92,871.79 |
| Jan-15 | FY 15 | Q 4 | E | 72,369.75 |
| Jan-15 | FY 15 | Q 4 | F | 40,461.10 |
| Jan-15 | FY 15 | Q 4 | G | 17,781.50 |
| Feb-15 | FY 15 | Q 4 | A | 673,210.35 |
| Feb-15 | FY 15 | Q 4 | B | 649,678.36 |
| Feb-15 | FY 15 | Q 4 | C | 415,308.09 |
| Feb-15 | FY 15 | Q 4 | D | 93,216.69 |
| Feb-15 | FY 15 | Q 4 | E | 75,885.39 |
| Feb-15 | FY 15 | Q 4 | F | 40,300.00 |
| Feb-15 | FY 15 | Q 4 | G | 22,256.76 |
| Mar-15 | FY 15 | Q 4 | A | 739,030.14 |
| Mar-15 | FY 15 | Q 4 | B | 672,688.31 |
| Mar-15 | FY 15 | Q 4 | C | 648,282.83 |
| Mar-15 | FY 15 | Q 4 | D | 125,675.88 |
| Mar-15 | FY 15 | Q 4 | E | 92,664.20 |
| Mar-15 | FY 15 | Q 4 | F | 40,300.00 |
| Mar-15 | FY 15 | Q 4 | G | 21,270.40 |
| Apr-15 | FY 16 | Q 1 | A | 910,786.40 |
| Apr-15 | FY 16 | Q 1 | B | 838,476.55 |
| Apr-15 | FY 16 | Q 1 | C | 672,602.40 |
| Apr-15 | FY 16 | Q 1 | D | 609,004.88 |
| Apr-15 | FY 16 | Q 1 | E | 109,387.64 |
| Apr-15 | FY 16 | Q 1 | F | 92,345.22 |
| Apr-15 | FY 16 | Q 1 | G | 58,055.48 |
| May-15 | FY 16 | Q 1 | A | 917,949.20 |
| May-15 | FY 16 | Q 1 | B | 798,071.82 |
| May-15 | FY 16 | Q 1 | C | 672,573.83 |
| May-15 | FY 16 | Q 1 | D | 563,909.79 |
| May-15 | FY 16 | Q 1 | E | 108,874.61 |
| May-15 | FY 16 | Q 1 | F | 99,204.79 |
| May-15 | FY 16 | Q 1 | G | 97,121.48 |
| Jun-15 | FY 16 | Q 1 | A | 8,867,272.78 |
| Jun-15 | FY 16 | Q 1 | B | 864,595.38 |
| Jun-15 | FY 16 | Q 1 | C | 672,669.77 |
| Jun-15 | FY 16 | Q 1 | D | 587,836.57 |
| Jun-15 | FY 16 | Q 1 | E | 128,142.07 |
| Jun-15 | FY 16 | Q 1 | F | 107,800.27 |
| Jun-15 | FY 16 | Q 1 | G | 82,756.97 |
| Jul-15 | FY 16 | Q 2 | A | 145,182.05 |
| Jul-15 | FY 16 | Q 2 | B | 127,001.07 |
| Jul-15 | FY 16 | Q 2 | C | 40,300.00 |
| Jul-15 | FY 16 | Q 2 | D | 21,339.14 |
| Jul-15 | FY 16 | Q 2 | E | 15,403.12 |
| Jul-15 | FY 16 | Q 2 | F | 6,526.25 |
| Jul-15 | FY 16 | Q 2 | G | 465.41 |
| Aug-15 | FY 16 | Q 2 | A | 1,101,051.52 |
| Aug-15 | FY 16 | Q 2 | B | 834,214.52 |
| Aug-15 | FY 16 | Q 2 | C | 663,638.65 |
| Aug-15 | FY 16 | Q 2 | D | 590,827.99 |
| Aug-15 | FY 16 | Q 2 | E | 197,747.95 |
| Aug-15 | FY 16 | Q 2 | F | 155,752.04 |
| Aug-15 | FY 16 | Q 2 | G | 147,927.23 |
| Sep-15 | FY 16 | Q 2 | A | 1,046,057.75 |
| Sep-15 | FY 16 | Q 2 | B | 927,190.60 |
| Sep-15 | FY 16 | Q 2 | C | 709,472.67 |
| Sep-15 | FY 16 | Q 2 | D | 563,062.79 |
| Sep-15 | FY 16 | Q 2 | E | 236,218.29 |
| Sep-15 | FY 16 | Q 2 | F | 169,333.56 |
| Sep-15 | FY 16 | Q 2 | G | 144,294.97 |
| Oct-15 | FY 16 | Q 3 | A | 2,780,386.82 |
| Oct-15 | FY 16 | Q 3 | B | 1,049,473.82 |
| Oct-15 | FY 16 | Q 3 | C | 858,644.08 |
| Oct-15 | FY 16 | Q 3 | D | 563,968.74 |
| Oct-15 | FY 16 | Q 3 | E | 426,858.55 |
| Oct-15 | FY 16 | Q 3 | F | 155,073.34 |
| Oct-15 | FY 16 | Q 3 | G | 153,563.13 |
| Nov-15 | FY 16 | Q 3 | A | 132,042.42 |
| Nov-15 | FY 16 | Q 3 | B | 130,633.85 |
| Nov-15 | FY 16 | Q 3 | C | 60,818.34 |
| Nov-15 | FY 16 | Q 3 | D | 46,468.69 |
| Nov-15 | FY 16 | Q 3 | E | 19,798.47 |
| Nov-15 | FY 16 | Q 3 | F | 456.40 |
| Nov-15 | FY 16 | Q 3 | G | (28,686.67) |
| Dec-15 | FY 16 | Q 3 | A | 1,114,863.98 |
| Dec-15 | FY 16 | Q 3 | B | 1,010,288.07 |
| Dec-15 | FY 16 | Q 3 | C | 888,850.79 |
| Dec-15 | FY 16 | Q 3 | D | 601,190.44 |
| Dec-15 | FY 16 | Q 3 | E | 550,225.79 |
| Dec-15 | FY 16 | Q 3 | F | 226,424.60 |
| Dec-15 | FY 16 | Q 3 | G | 140,539.45 |
| Jan-16 | FY 16 | Q 4 | A | 1,221,077.53 |
| Jan-16 | FY 16 | Q 4 | B | 1,135,349.83 |
| Jan-16 | FY 16 | Q 4 | C | 863,530.80 |
| Jan-16 | FY 16 | Q 4 | D | 588,382.43 |
| Jan-16 | FY 16 | Q 4 | E | 534,577.49 |
| Jan-16 | FY 16 | Q 4 | F | 249,490.21 |
| Jan-16 | FY 16 | Q 4 | G | 144,523.53 |
| Feb-16 | FY 16 | Q 4 | A | 1,162,356.30 |
| Feb-16 | FY 16 | Q 4 | B | 862,032.55 |
| Feb-16 | FY 16 | Q 4 | C | 634,191.59 |
| Feb-16 | FY 16 | Q 4 | D | 580,227.57 |
| Feb-16 | FY 16 | Q 4 | E | 534,793.82 |
| Feb-16 | FY 16 | Q 4 | F | 266,279.21 |
| Feb-16 | FY 16 | Q 4 | G | 152,122.93 |
| Mar-16 | FY 16 | Q 4 | A | 1,418,886.31 |
| Mar-16 | FY 16 | Q 4 | B | 1,253,947.77 |
| Mar-16 | FY 16 | Q 4 | C | 728,817.69 |
| Mar-16 | FY 16 | Q 4 | D | 589,371.75 |
| Mar-16 | FY 16 | Q 4 | E | 553,435.24 |
| Mar-16 | FY 16 | Q 4 | F | 364,436.39 |
| Mar-16 | FY 16 | Q 4 | G | 290,963.40 |
| Apr-16 | FY 17 | Q 1 | A | 1,539,402.43 |
| Apr-16 | FY 17 | Q 1 | B | 1,250,625.85 |
| Apr-16 | FY 17 | Q 1 | C | 595,116.01 |
| Apr-16 | FY 17 | Q 1 | D | 580,387.20 |
| Apr-16 | FY 17 | Q 1 | E | 528,058.41 |
| Apr-16 | FY 17 | Q 1 | F | 308,263.33 |
| Apr-16 | FY 17 | Q 1 | G | 150,746.44 |
| May-16 | FY 17 | Q 1 | A | 1,531,447.85 |
| May-16 | FY 17 | Q 1 | B | 1,285,027.76 |
| May-16 | FY 17 | Q 1 | C | 654,737.79 |
| May-16 | FY 17 | Q 1 | D | 591,821.10 |
| May-16 | FY 17 | Q 1 | E | 499,918.72 |
| May-16 | FY 17 | Q 1 | F | 254,173.61 |
| May-16 | FY 17 | Q 1 | G | 146,508.60 |
| Jun-16 | FY 17 | Q 1 | A | 1,581,348.88 |
| Jun-16 | FY 17 | Q 1 | B | 1,507,006.18 |
| Jun-16 | FY 17 | Q 1 | C | 588,081.83 |
| Jun-16 | FY 17 | Q 1 | D | 578,200.40 |
| Jun-16 | FY 17 | Q 1 | E | 561,126.57 |
| Jun-16 | FY 17 | Q 1 | F | 334,345.69 |
| Jun-16 | FY 17 | Q 1 | G | 129,429.41 |
Regards