Spreadsheet: 543229d1508284281-linking-and-colouring-pivit-data-cf-cell-above-gt-or-lt-red-or-green-2
Sheet: Pivot

Year | 2017
Month | (All)
Week | (All) |  |  | If you keep all your data here, you can filter by [NAME] to show most recent week(s).
 | Column Labels
 | Microsoft |  | Nokia |  | UberEats |  | Square POS |  | Epsilon |  | Sabre |  | Solana |  | Total Sales | Total change
Row Labels | Sales | change | Sales | change | Sales | change | Sales | change | Sales | change | Sales | change | Sales | change
1/1/2017 - 1/7/2017 |  |  |  |  | 172.84 | 172.84 | 325.05 | 325.05 |  |  |  |  |  |  | 497.89 | 497.89
1/8/2017 - 1/14/2017 | 195.72 | 195.72 | 17.97 | 17.97 | 101.91 | 101.91 | 231.6800000000001 | 231.6800000000001 |  |  |  |  |  |  | 547.2800000000001 | 547.2800000000001
1/15/2017 - 1/21/2017 | 144.8 | 144.8 | 75.89 | 75.89 | 200.82 | 200.82 | 407.14 | 407.14 |  |  |  |  |  |  | 828.65 | 828.65
1/22/2017 - 1/28/2017 | 268.63 | 268.63 | 115.83 | 115.83 | 276.75 | 276.75 | 1265.79 | 1265.79 |  |  |  |  |  |  | 1927 | 1927
1/29/2017 - 2/4/2017 | 331.36 | 331.36 | 45.92 | 45.92 | 273.75 | 273.75 | 903.89 | 903.89 |  |  |  |  |  |  | 1554.92 | 1554.92
2/12/2017 - 2/18/2017 | 237.97 | 237.97 | 45.92 | 45.92 | 177.37 | 177.37 | 1164.9 | 1164.9 |  |  |  |  |  |  | 1626.16 | 1626.16
2/19/2017 - 2/25/2017 | 223.9 | 223.9 | 45.92 | 45.92 | 107.09 | 107.09 | 2164.06 | 2164.06 |  |  |  |  |  |  | 2540.97 | 2540.97
2/26/2017 - 3/4/2017 | 269.33 | 269.33 | 45.92 | 45.92 | 191.48 | 191.48 | 1184.51 | 1184.51 |  |  |  |  |  |  | 1691.24 | 1691.24
3/5/2017 - 3/11/2017 | 395.75 | 395.75 | 57.9 | 57.9 | 89.43 | 89.43 | 1159.6 | 1159.6 |  |  |  |  |  |  | 1702.68 | 1702.68
3/12/2017 - 3/18/2017 | 313.15 | 313.15 | 63.89 | 63.89 | 220.38 | 220.38 | 1647.74 | 1647.74 |  |  |  |  |  |  | 2245.16 | 2245.16
3/19/2017 - 3/25/2017 | 151.19 | 151.19 | 85.86 | 85.86 | 87.94 | 87.94 | 1329.28 | 1329.28 |  |  |  |  |  |  | 1654.27 | 1654.27
3/26/2017 - 4/1/2017 | 285.88 | 285.88 | 69.87 | 69.87 | 127.4 | 127.4 | 1255.19 | 1255.19 |  |  |  |  |  |  | 1738.34 | 1738.34
4/2/2017 - 4/8/2017 | 302.42 | 302.42 | 44.93 | 44.93 | 181.89 | 181.89 | 3819.01 | 3819.01 |  |  |  |  |  |  | 4348.25 | 4348.25
4/9/2017 - 4/15/2017 | 271 | 271 | 14.97 | 14.97 | 188.84 | 188.84 | 931.55 | 931.55 |  |  |  |  |  |  | 1406.36 | 1406.36
4/16/2017 - 4/22/2017 | 379.25 | 379.25 | 0 | 0 | 187.87 | 187.87 | 1112.77 | 1112.77 |  |  |  |  |  |  | 1679.89 | 1679.89
4/23/2017 - 4/29/2017 | 299.1 | 299.1 | 33.94 | 33.94 | 142.87 | 142.87 | 1330.63 | 1330.63 |  |  |  |  |  |  | 1806.54 | 1806.54
4/30/2017 - 5/6/2017 | 228.01 | 228.01 | 37.93 | 37.93 | 113.92 | 113.92 | 1553.57 | 1553.57 |  |  |  |  |  |  | 1933.43 | 1933.43
5/7/2017 - 5/13/2017 | 340.85 | 340.85 | 51.93 | 51.93 | 104.93 | 104.93 | 1673.82 | 1673.82 |  |  |  |  |  |  | 2171.53 | 2171.53
5/14/2017 - 5/20/2017 | 344.8 | 344.8 | 44.94 | 44.94 | 266.15 | 266.15 | 1611.14 | 1611.14 |  |  |  |  |  |  | 2267.03 | 2267.03
5/21/2017 - 5/27/2017 | 376.6 | 376.6 | 36.95 | 36.95 | 60.07 | 60.07 | 2095.76 | 2095.76 |  |  |  |  |  |  | 2569.38 | 2569.38
5/28/2017 - 6/3/2017 | 420.35 | 420.35 | 36.95 | 36.95 | 134.11 | 134.11 | 3858.78 | 3858.78 |  |  |  |  |  |  | 4450.190000000001 | 4450.190000000001
6/4/2017 - 6/10/2017 | 297.15 | 297.15 | 59.92 | 59.92 | 233.58 | 233.58 | 3112.12 | 3112.12 |  |  |  |  |  |  | 3702.77 | 3702.77
6/11/2017 - 6/17/2017 | 0 | 0 | 29.96 | 29.96 | 104.89 | 104.89 | 4802.28 | 4802.28 |  |  |  |  |  |  | 4937.13 | 4937.13
6/18/2017 - 6/24/2017 | 248.45 | 248.45 | 6.99 | 6.99 | 549.32 | 549.32 | 5534.01 | 5534.01 |  |  |  |  |  |  | 6338.77 | 6338.77
6/25/2017 - 7/1/2017 | 216.6 | 216.6 | 29.96 | 29.96 | 322.81 | 322.81 | 7458.42 | 7458.42 |  |  |  |  |  |  | 8027.79 | 8027.79
7/2/2017 - 7/8/2017 | 219.6 | 219.6 | 44.95 | 44.95 | 370.94 | 370.94 | 8658.23 | 8658.23 |  |  |  |  |  |  | 9293.72 | 9293.72
7/9/2017 - 7/15/2017 | 0 | 0 | 0 | 0 | 328.16 | 328.16 | 7061.820000000001 | 7061.820000000001 |  |  |  |  |  |  | 7389.98 | 7389.98
7/16/2017 - 7/22/2017 | 315 | 315 | 59.92 | 59.92 | 620.56 | 620.56 | 6903.02 | 6903.02 |  |  |  |  |  |  | 7898.5 | 7898.5
7/23/2017 - 7/29/2017 | 395.5 | 395.5 | 45 | 45 | 553.69 | 553.69 | 7470.65 | 7470.65 |  |  |  |  |  |  | 8464.84 | 8464.84
7/30/2017 - 8/5/2017 | 418.35 | 418.35 | 44.94 | 44.94 | 784.48 | 784.48 | 10898.12 | 10898.12 |  |  |  |  |  |  | 12145.89 | 12145.89
8/6/2017 - 8/12/2017 | 438.25 | 438.25 | 28.96 | 28.96 | 443.9 | 443.9 | 5628.679999999998 | 5628.679999999998 |  |  |  |  |  |  | 6539.789999999998 | 6539.789999999998
8/13/2017 - 8/19/2017 | 473 | 473 | 22.97 | 22.97 | 461.28 | 461.28 | 7109.62 | 7109.62 | 526.96 | 526.96 | 0 | 0 |  |  | 8593.83 | 8593.83
8/20/2017 - 8/26/2017 | 481.95 | 481.95 | 29.96 | 29.96 | 236.85 | 236.85 | 5786.83 | 5786.83 | 450 | 450 | 749.22 | 749.22 |  |  | 7734.81 | 7734.81
8/27/2017 - 9/2/2017 | 416.35 | 416.35 | 44.94 | 44.94 | 383.81 | 383.81 | 8119.67 | 8119.67 | 338.17 | 338.17 | 728.66 | 728.66 |  |  | 10031.6 | 10031.6
9/3/2017 - 9/9/2017 | 494.85 | 494.85 | 127.84 | 127.84 | 177.33 | 177.33 | 8241.13 | 8241.13 | 307 | 307 | 690.93 | 690.93 | 435.68 | 435.68 | 10474.76 | 10474.76
9/10/2017 - 9/16/2017 | 321.95 | 321.95 | 44.94 | 44.94 | 356.84 | 356.84 | 6656.32 | 6656.32 | 312.19 | 312.19 | 793.13 | 793.13 | 487.57 | 487.57 | 8972.939999999999 | 8972.939999999999
9/17/2017 - 9/23/2017 | 312 | 312 | 30.96 | 30.96 | 290.67 | 290.67 | 6719.54 | 6719.54 | 325.5 | 325.5 | 656.21 | 656.21 | 373.51 | 373.51 | 8708.390000000001 | 8708.390000000001
9/24/2017 - 9/30/2017 | 391.5 | 391.5 | 62.92 | 62.92 | 185.3 | 185.3 | 8252.27 | 8252.27 | 350.5 | 350.5 | 973.43 | 973.43 | 551.29 | 551.29 | 10767.21 | 10767.21
10/1/2017 - 10/7/2017 | 366.4 | 366.4 | 30.96 | 30.96 | 250.74 | 250.74 | 6233.5 | 6233.5 | 367 | 367 |  |  |  |  | 7248.6 | 7248.6
10/8/2017 - 10/9/2017 | 540 | 540 | 15.98 | 15.98 | 138.38 | 138.38 | 6697 | 6697 |  |  |  |  |  |  | 7391.36 | 7391.36
Grand Total | 12126.96 | 12126.96 | 1735.500000000001 | 1735.500000000001 | 10201.34 | 10201.34 | 162369.09 | 162369.09 | 2977.32 | 2977.32 | 4591.58 | 4591.58 | 1848.05 | 1848.05 | 195849.84 | 195849.84