Spreadsheet: 90076d1289835486-pivot-table-help-trial
Sheet: Sheet4

 | Data
Tenant | Sum of Jan/09 | Sum of Feb/09 | Sum of Mar/09 | Sum of Apr/09 | Sum of May/09 | Sum of Jun/09 | Sum of Jul/09 | Sum of Aug/09 | Sum of Sep/09 | Sum of Oct/09 | Sum of Nov/09 | Sum of Dec/09 | Sum of Jan/10 | Sum of Feb/10 | Sum of Mar/10 | Sum of Apr/10 | Sum of May/10 | Sum of Jun/10 | Sum of Jul/10 | Sum of Aug/10 | Sum of Sep/10
ADIL ISIK | 0 | 0 | 0 | 628.38 | 1558.73 | 1661.39 | 1780.93 | 1665.02 | 2365.03 | 1727.4 | 2325.47 | 1774.23 | 2157.35 | 2330.32 | 2050.49 | 1873.8 | 2099.8 | 2260.03 | 2294.25 | 2063.59 | 3001.41
ADYAMO BOWLING | 690.01 | 761.99 | 679.54 | 524.08 | 575.53 | 310.39 | 0 | -310.39 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AROW | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 758.45 | 1145.38 | 1051.14 | 1380.44 | 953.38 | 1151.34 | 0 | 1568.63 | 2306.51 | 0 | 0 | 0
ARSLANLI | 837.03 | 627.75 | 593.25 | 511.18 | 439.78 | 392.25 | 255.3 | 484.81 | 476.18 | 635.64 | 153.73 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BAY DONER | 2468.37 | 2686.09 | 2560.71 | 2312.81 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BENETTON | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3186.27 | 2645.9 | 1926.33 | 2108.29
BERNARDO | 1961.08 | 2312.24 | 2484.56 | 2014.54 | 1870.64 | 1560.98 | 2192.47 | 3095.58 | 2033.32 | 2671.73 | 1933.25 | 2984.64 | 2285.94 | 2384.39 | 1931.08 | 1759.02 | 2580.6 | 1983.04 | 2925.41 | 2882.88 | 3035.69
BSSD | 3446.9 | 3276.58 | 3051.07 | 2734.05 | 2519.47 | 2383.93 | 1641.59 | 4331.14 | 4335.45 | 5471.5 | 7078.16 | 6759.04 | 6129.38 | 5151.47 | 4757.14 | 3838.9 | 5644.48 | 4648.34 | 3582.88 | 0 | 7103.34
BUCURUK | 522.73 | 507.23 | 359.12 | 327.67 | 579 | 510.48 | 462.42 | 347.35 | 762.29 | 537.27 | 0 | 0 | 0 | 0 | 3897.51 | 516.74 | 837.57 | 810.7 | 0 | 0 | 0
C.C.S | 0 | 0 | 10059.51 | 3613.39 | 3590.03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
COLINS | 2526.02 | 2407.11 | 2206.97 | 2391.6 | 2486.04 | 2516.42 | 2840.83 | 2484.26 | 3484.47 | 1166.21 | 0 | 0 | 3158.22 | 12292.25 | 3333.25 | 4467.37 | 0 | 8976.43 | 0 | 0 | 0
COLLEZIONE | 5718.69 | 4843.19 | 4829.33 | 5617.86 | 4935.61 | 5457.22 | 5624.85 | 5247.48 | 7291.46 | 4873.08 | 6678.41 | 6441.35 | 7627.36 | 7428.43 | 6572.79 | 5014.93 | 6158.73 | 6143.07 | 7453.56 | 0 | 13980.42
D&R | 1389.75 | 1218.55 | 1274.42 | 1023.23 | 1025.9 | 1199.37 | 1020.82 | 479.89 | 1040.01 | 1144.35 | 1468.62 | 2081.86 | 1689.47 | 462.03 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DEFACTO | 0 | 0 | 0 | 2486.6 | 5349.66 | 5005.98 | 4195.75 | 4071.21 | 6060.41 | 4799.51 | 9002.93 | 5855.34 | 7343.8 | 6534.61 | 6423.69 | 7138.66 | 8934.19 | 9591.31 | 8184.26 | 7536.87 | 10305.21
DEICHMANN | 2669.19 | 2205.02 | 2676.98 | 4705.58 | -1611.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DERIMOD/BATA | 1954.64 | 2491.48 | 1417.12 | 1560.62 | 1209.64 | 1513.4 | 931.46 | 774.64 | 1767.95 | 2538.38 | 1196 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 21400.13 | 0
DIVARESE | 1258 | 1226.4 | 1645.69 | 1758.69 | 1975.64 | 1177.24 | 957.92 | 2304.24 | 1677.61 | 919.08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DUFY | 344.48 | 434.23 | 383.81 | 446.66 | 463.64 | 610.72 | 393.76 | 393.69 | 481.32 | 0 | 268.71 | 1487.35 | 480.38 | 575.14 | 581.47 | 649.86 | 958.52 | 916.15 | 0 | 0 | 0
ESSE | 0 | 0 | 6926.63 | 2432.55 | 3002.42 | 2727.14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FLO | 2365.86 | 1962.93 | 2680.49 | 3398.31 | 3492.19 | 3511.95 | 3045.74 | 2537.86 | 4515.83 | 1632.65 | 0 | 0 | 4887.82 | 17628.87 | 6022.6 | 7207.13 | 8225.4 | 6524.92 | 0 | 0 | 0
GGS | 2073.42 | 1884.38 | 2191.66 | 2446.94 | 2079.56 | 2126.12 | 1451.22 | 1357.59 | 1700.46 | 1356.71 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 928.66 | 901.39 | 958.58 | 1099.47 | 1347.34 | 1204.59 | 1492.9 | 1428.25 | 0 | 0 | 2381.43 | 48.48 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
HATEMOGLU | 0 | 0 | 6918.38 | 3225.54 | 3937.79 | 2990.75 | 2536.06 | 2746.34 | 4482.97 | 3602.31 | 0 | 0 | 16528.05 | 4950.68 | 5622.31 | 6411.84 | 6262.13 | 6767.04 | 4936.19 | 3890.04 | 0
HOSTA | 405.86 | 337.41 | 331.89 | 344.87 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
INCI | 1165.58 | 2665.68 | 1871.27 | 2826.16 | 4964.42 | 3687.54 | 3310.48 | 3292.2 | 3558.21 | 2542.37 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
INTERSPORT | 3572.68 | 4335.86 | 5912.33 | 7133.21 | 8221.17 | 8287.64 | 6741.14 | 5653.63 | 8535.43 | 11016.95 | 2068.19 | 0 | 0 | 0 | 17290.22 | 6263.21 | 6066.88 | 4904.46 | 0 | 0 | 0
JEANS LAB-LEE COOPER | 79.5 | 127.55 | 22.19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] A.KIGILI | 2143.59 | 2202.65 | 1719.96 | 2167.63 | 1740.03 | 2133.18 | 1618.37 | 1626 | 2381.06 | 810.04 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
KOTON | 4756.08 | 3848.89 | 3901.65 | 4388.37 | 4647.03 | 4115.67 | 4119.47 | 3875.94 | 5882.85 | 2551.34 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
L.C.W. | 7848.81 | 6900.19 | 6703.42 | 9803.87 | 10967.53 | 11300.69 | 11419.41 | 8898.58 | 19169.38 | 10630.76 | 18428.47 | 9950.37 | 13965.58 | 12258.81 | 11780.12 | 15774.25 | 19469.72 | 19290.82 | 18004.65 | 16472.03 | 0
LCW | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22080.93
MADO | 0 | 1336.81 | 1282.58 | 1418.66 | 1458.21 | 0 | 0 | 1049.41 | 2745.43 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
MANGO | 4533.07 | 0 | 5993.09 | 3826.55 | 4466.2 | 0 | 4120.59 | 5582.11 | 3941.5 | 7645.11 | 4136.95 | 5834.04 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
MATRAS | 1183.97 | 1016.25 | 901.2 | 820.39 | 928.99 | 1095.76 | 518.63 | 489.02 | 859.96 | 367.25 | 0 | 2809.67 | 1046.08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
MAVI JEANS | 3050.42 | 3060.77 | 3580.64 | 4325.29 | 4214 | 3750.03 | 3531.85 | 3125.81 | 2826.89 | 3401.68 | 4228.97 | 2560.56 | 4339.31 | 4632.25 | 5126.13 | 6138.92 | 6280.81 | 6024.46 | 6333.82 | 0 | 14680.68
MUDO | 6568.33 | 0 | 15974.56 | 4825.21 | 4555.19 | 4338.08 | 4450.97 | 0 | 0 | 15254.25 | 0 | 12983.11 | 0 | 6872.62 | 13674.39 | 6713.88 | 0 | 14489.92 | 15320.69 | 0 | 14766.57
NATUREL DONER | 608.44 | 668.27 | 934.56 | 611.59 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NETWORK-FABRIKA | 3502.24 | 2895.67 | 4335.76 | 4128.19 | 5148.24 | 3359.42 | 2294.97 | 2171.62 | 3882.42 | 2153.35 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NIKE | 146.47 | 1600.49 | 1914.43 | 2046.54 | 1702.75 | 2794.5 | 1265.34 | 790.77 | 829.7 | 717.1 | 809.26 | 1061.75 | 1175.93 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
OTANTIK KUMPIR | 0 | 631.51 | 614.18 | 614.58 | 1326.32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PETLIFE | 73.6 | 77.22 | 73.17 | 83.24 | 61.02 | 49.76 | 63.95 | 38.87 | 54.92 | 97.88 | 0 | 284.76 | 258.04 | 215.64 | 175.35 | 0 | 187.5 | 347.96 | 0 | 0 | 0
PLAYLAND | 892.87 | 1019.65 | 792.15 | 0 | 0 | -150.98 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PLAYLAND GOCART | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 469.66 | 349.94 | 158.42 | 124.97 | 266.84 | 399.58 | 0 | 0 | 0 | 0 | 0 | 0
PORLAND STUDIO | 1669.75 | 2598.61 | 2124.24 | 2234.82 | 2334.32 | 1961.73 | 2633.86 | 4660.66 | 1982.39 | 900.94 | 0 | 4800.94 | 2442.01 | 2099.14 | 2642.56 | 1104.49 | 0 | 0 | 0 | 0 | 3017.83
QUIKSILVER | 452.28 | 419.45 | 398.5 | 370.46 | 330.56 | 514.24 | 576.26 | 446.74 | 437 | 294.42 | 0 | 1106.83 | 370.03 | 315.06 | 236.53 | 0 | 0 | 0 | 0 | 0 | 0
RODI DENIM | 0 | 0 | 0 | 0 | 864.51 | 2338.54 | 2099.92 | 1624.19 | 1931.22 | 1434.77 | 3312.73 | 2306.21 | 2690.42 | 1705.34 | 1614.65 | 2085.6 | 924 | 0 | 0 | 0 | 0
SABRI OZEL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1553.9
TAC EVI | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 908.99 | 413.45 | 0 | 917.22
TCHIBO | 0 | 0 | 3680.89 | 1141.02 | 947.73 | 904.79 | 691.28 | 748.8 | 1103.58 | 1578.85 | 1574.95 | 966.68 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TEKIN ACAR | 774.67 | 1220.39 | 970.63 | 1045.03 | 1243.5 | 1208.31 | 789.97 | 863.9 | 1010.62 | 828.57 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TEKNOSA | 7352.47 | 8367.21 | 8594.74 | 9813.66 | 8501.23 | 9237.08 | 9772.83 | 10545.92 | 15457.47 | 12226.1 | 10218.41 | 11318.5 | 0 | 16583.18 | 7301.47 | 7474.9 | 9144.26 | 10153.54 | 0 | 0 | 0
TIFFANY | 2176.3 | 2154.97 | 1572.13 | 1471.69 | 1599.39 | 1706.4 | 1522.44 | 1251.31 | 1985.94 | 593.61 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOMMY | 986.25 | 907.04 | 876.92 | 995.41 | 988.13 | 963.37 | 696.14 | 571.66 | 785.94 | 660.73 | 53.73 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total: | 92128.86 | 86698.29 | 138078.08 | 121590.3 | 121203.01 | 109274.48 | 101040.71 | 99078.51 | 135239.27 | 120555.99 | 89522.1 | 99322.56 | 94942.21 | 115685.24 | 114613.88 | 95428.08 | 96134.22 | 120267.02 | 79208.33 | 64398.03 | 103543.09
TOYZZ SHOP | 1881.14 | 1368.26 | 1651.29 | 1528.14 | 1397.04 | 1390.97 | 1269.66 | 1307.25 | 1626.28 | 763.86 | 0 | 6237.55 | 2774.14 | 2173.87 | 1542.47 | 1513.45 | 1265.49 | 1370.01 | 0 | 0 | 0
US POLO | 0 | 2019.31 | 2554.28 | 2689.21 | 2101.86 | 2385.58 | 1983.46 | 1652.69 | 2636.35 | 2124.55 | 3007.75 | 2306.82 | 2709.42 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
YKM | 4668.97 | 4904.34 | 4729.92 | 5567.62 | 5530.04 | 4897.15 | 4611.96 | 5232.81 | 8660.95 | 7478.82 | 7700.66 | 6152.92 | 9378.07 | 7870.92 | 9446.24 | 9326.89 | 9364.42 | 8336.47 | 7000.63 | 7941.44 | 6518.13
YUMOS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 228.46 | 112.64 | 0 | 159.75
YUMOS -KEZBAN GOKMESE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 149.12
ZEPLIN | 480.69 | 267.28 | 167.69 | 109.14 | 136.24 | 144.71 | 113.74 | 139.66 | 479.02 | 178.76 | 0 | 0 | 0 | 0 | 1040.5 | 154.24 | 161.09 | 98.12 | 0 | 0 | 0
ZUMO | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 284.72 | 164.6
Grand Total | 184257.72 | 173396.58 | 276156.16 | 243180.6 | 242406.02 | 218548.96 | 202081.42 | 198157.02 | 270478.54 | 241111.98 | 179044.2 | 198645.12 | 189884.42 | 231370.48 | 229227.76 | 190856.16 | 192268.44 | 240534.04 | 158416.66 | 128796.06 | 207086.18