Spreadsheet: 126137d1319544710-pivot-filter-based-on-custom-values-not-working-sample
Sheet: Sheet1

Account | Opco | Period | USD
3rd Party Debtors | 1137 | 002.2011 | 0
3rd Party Debtors | 1032 | 002.2011 | 0
3rd Party Debtors | 1219 | 002.2011 | 127275547
3rd Party Debtors | 1281 | 002.2011 | 81271780
3rd Party Debtors | 1646 | 002.2011 | 8749073
3rd Party Debtors | 4741 | 002.2011 | 2108602
3rd Party Debtors | 1941 | 002.2011 | 2815524
3rd Party Debtors | 1379 | 002.2011 | 9951091
3rd Party Debtors | 1031 | 002.2011 | 2373391
3rd Party Debtors | 1919 | 002.2011 | 6158560
3rd Party Debtors | 1330 | 002.2011 | 7080559
3rd Party Debtors | 1993 | 002.2011 | 0
3rd Party Debtors | 1993 | 002.2011 | 0
3rd Party Debtors | 3591 | 002.2011 | 0
3rd Party Debtors | 0493 | 002.2011 | 0
3rd Party Debtors | 1269 | 002.2011 | 24018015
3rd Party Debtors | 1909 | 002.2011 | 43781439
3rd Party Debtors | 4356 | 002.2011 | 2300781
3rd Party Debtors | 4357 | 002.2011 | -24895644
3rd Party Debtors | 1063 | 002.2011 | 524685
3rd Party Debtors | 3071 | 002.2011 | 21625
3rd Party Debtors | 1155 | 002.2011 | 1773000
3rd Party Debtors | 2254 | 002.2011 | 752710
3rd Party Debtors | 2997 | 002.2011 | 0
3rd Party Debtors | 1226 | 002.2011 | 4860362
3rd Party Debtors | 1227 | 002.2011 | 70298
3rd Party Debtors | 1227 | 002.2011 | 6879957
3rd Party Debtors | 1307 | 002.2011 | 0
3rd Party Creditors | 1031 | 002.2011 | -508223
3rd Party Creditors | 1919 | 002.2011 | -4065204
3rd Party Creditors | 1330 | 002.2011 | -4798214
3rd Party Creditors | 1330 | 002.2011 | 0
3rd Party Creditors | 1993 | 002.2011 | 0
3rd Party Creditors | 1993 | 002.2011 | 0
3rd Party Creditors | 0493 | 002.2011 | 0
3rd Party Creditors | 1269 | 002.2011 | -4981979
3rd Party Creditors | 1909 | 002.2011 | -2854429
3rd Party Creditors | 4356 | 002.2011 | -3319957
3rd Party Creditors | 4357 | 002.2011 | -20661125
3rd Party Creditors | 1063 | 002.2011 | 612
3rd Party Creditors | 3071 | 002.2011 | 3272
3rd Party Creditors | 2876 | 002.2011 | -667
3rd Party Creditors | 1137 | 002.2011 | 0
3rd Party Creditors | 1032 | 002.2011 | 0
3rd Party Creditors | 1219 | 002.2011 | -77418994
3rd Party Creditors | 1281 | 002.2011 | -5084543
3rd Party Creditors | 1646 | 002.2011 | 0
3rd Party Creditors | 4741 | 002.2011 | -98200
3rd Party Creditors | 1941 | 002.2011 | -6052
3rd Party Creditors | 2039 | 002.2011 | -1065
3rd Party Creditors | 1379 | 002.2011 | -5304819
3rd Party Creditors | 2254 | 002.2011 | 1066000
3rd Party Creditors | 2997 | 002.2011 | -4021551
3rd Party Creditors | 1226 | 002.2011 | 1910
3rd Party Creditors | 1227 | 002.2011 | -6732801
3rd Party Creditors | 1307 | 002.2011 | -1641
3rd Party Debtors | 1137 | 003.2011 | 0
3rd Party Debtors | 1032 | 003.2011 | 0
3rd Party Debtors | 1219 | 003.2011 | 121986054
3rd Party Debtors | 1281 | 003.2011 | 76498397
3rd Party Debtors | 1646 | 003.2011 | 8952730
3rd Party Debtors | 4741 | 003.2011 | 3044247
3rd Party Debtors | 1941 | 003.2011 | 3280915
3rd Party Debtors | 1379 | 003.2011 | 11681113
3rd Party Debtors | 1031 | 003.2011 | 2418201
3rd Party Debtors | 1919 | 003.2011 | 8718363
3rd Party Debtors | 1330 | 003.2011 | 6628616
3rd Party Debtors | 1993 | 003.2011 | 0
3rd Party Debtors | 1993 | 003.2011 | 0
3rd Party Debtors | 3591 | 003.2011 | 0
3rd Party Debtors | 0493 | 003.2011 | 0
3rd Party Debtors | 1269 | 003.2011 | 18810252
3rd Party Debtors | 1909 | 003.2011 | 54259222
3rd Party Debtors | 4356 | 003.2011 | 2369501
3rd Party Debtors | 4357 | 003.2011 | -25205427
3rd Party Debtors | 1063 | 003.2011 | 530235
3rd Party Debtors | 3071 | 003.2011 | 21625
3rd Party Debtors | 1155 | 003.2011 | 1485000
3rd Party Debtors | 1862 | 003.2011 | 0
3rd Party Debtors | 2254 | 003.2011 | 646000
3rd Party Debtors | 2997 | 003.2011 | 0
3rd Party Debtors | 1226 | 003.2011 | 3808323
3rd Party Debtors | 1227 | 003.2011 | 70298
3rd Party Debtors | 1227 | 003.2011 | 6360953
3rd Party Debtors | 1307 | 003.2011 | 0
3rd Party Creditors | 2876 | 003.2011 | -663
3rd Party Creditors | 1137 | 003.2011 | 0
3rd Party Creditors | 1032 | 003.2011 | 0
3rd Party Creditors | 1219 | 003.2011 | -84832365
3rd Party Creditors | 1281 | 003.2011 | -5226113
3rd Party Creditors | 1646 | 003.2011 | 0
3rd Party Creditors | 4741 | 003.2011 | 35469
3rd Party Creditors | 1941 | 003.2011 | -6225
3rd Party Creditors | 2039 | 003.2011 | -1832
3rd Party Creditors | 1379 | 003.2011 | -214459
3rd Party Creditors | 1031 | 003.2011 | -113154
3rd Party Creditors | 1919 | 003.2011 | 1126
3rd Party Creditors | 1330 | 003.2011 | -296532
3rd Party Creditors | 1330 | 003.2011 | 0
3rd Party Creditors | 1993 | 003.2011 | 0
3rd Party Creditors | 1993 | 003.2011 | 0
3rd Party Creditors | 0493 | 003.2011 | 0
3rd Party Creditors | 1269 | 003.2011 | -4802018
3rd Party Creditors | 1909 | 003.2011 | -826365
3rd Party Creditors | 4356 | 003.2011 | -6458669
3rd Party Creditors | 4357 | 003.2011 | -15229037
3rd Party Creditors | 1063 | 003.2011 | 0
3rd Party Creditors | 3071 | 003.2011 | 3272
3rd Party Creditors | 1155 | 003.2011 | 0
3rd Party Creditors | 1862 | 003.2011 | 0
3rd Party Creditors | 2254 | 003.2011 | 0
3rd Party Creditors | 2997 | 003.2011 | 0
3rd Party Creditors | 1226 | 003.2011 | -29171
3rd Party Creditors | 1227 | 003.2011 | -4672177
3rd Party Creditors | 1307 | 003.2011 | 0
3rd Party Debtors | 1137 | 004.2011 | 0
3rd Party Debtors | 1032 | 004.2011 | 0
3rd Party Debtors | 1219 | 004.2011 | 139837231
3rd Party Debtors | 1281 | 004.2011 | 73430823
3rd Party Debtors | 1646 | 004.2011 | 10090939
3rd Party Debtors | 4741 | 004.2011 | 2632068
3rd Party Debtors | 1941 | 004.2011 | 3000482
3rd Party Debtors | 1379 | 004.2011 | 11916049
3rd Party Debtors | 1031 | 004.2011 | 2909115
3rd Party Debtors | 1919 | 004.2011 | 8350947
3rd Party Debtors | 1330 | 004.2011 | 6413347
3rd Party Debtors | 1993 | 004.2011 | 0
3rd Party Debtors | 1993 | 004.2011 | 0
3rd Party Debtors | 3591 | 004.2011 | 0
3rd Party Debtors | 0493 | 004.2011 | 0
3rd Party Debtors | 1269 | 004.2011 | 18268142
3rd Party Debtors | 1909 | 004.2011 | 40983009
3rd Party Debtors | 4356 | 004.2011 | 2544801
3rd Party Debtors | 4357 | 004.2011 | -25424417
3rd Party Debtors | 1063 | 004.2011 | 536979
3rd Party Debtors | 3071 | 004.2011 | 21625
3rd Party Debtors | 1155 | 004.2011 | 2036000
3rd Party Debtors | 2254 | 004.2011 | 689000
3rd Party Debtors | 2997 | 004.2011 | 0
3rd Party Debtors | 1226 | 004.2011 | 5224716
3rd Party Debtors | 1227 | 004.2011 | 70298
3rd Party Debtors | 1227 | 004.2011 | 7735812
3rd Party Debtors | 1307 | 004.2011 | 0
3rd Party Creditors | 2876 | 004.2011 | -657
3rd Party Creditors | 1137 | 004.2011 | 0
3rd Party Creditors | 1032 | 004.2011 | 0
3rd Party Creditors | 1219 | 004.2011 | -85589863
3rd Party Creditors | 1281 | 004.2011 | -5467854
3rd Party Creditors | 1646 | 004.2011 | 52
3rd Party Creditors | 4741 | 004.2011 | -2330
3rd Party Creditors | 1941 | 004.2011 | -5734
3rd Party Creditors | 2039 | 004.2011 | -2461
3rd Party Creditors | 1379 | 004.2011 | -204851
3rd Party Creditors | 1031 | 004.2011 | -369264
3rd Party Creditors | 1919 | 004.2011 | -4701647
3rd Party Creditors | 1330 | 004.2011 | -2335656
3rd Party Creditors | 1330 | 004.2011 | 0
3rd Party Creditors | 1993 | 004.2011 | 0
3rd Party Creditors | 1993 | 004.2011 | 0
3rd Party Creditors | 0493 | 004.2011 | 0
3rd Party Creditors | 1269 | 004.2011 | -6278604
3rd Party Creditors | 1909 | 004.2011 | -2229519
3rd Party Creditors | 4356 | 004.2011 | -6264131
3rd Party Creditors | 4357 | 004.2011 | -11189860
3rd Party Creditors | 1063 | 004.2011 | 0
3rd Party Creditors | 3071 | 004.2011 | 3272
3rd Party Creditors | 2254 | 004.2011 | -627000
3rd Party Creditors | 2997 | 004.2011 | 0
3rd Party Creditors | 1226 | 004.2011 | -7671
3rd Party Creditors | 1227 | 004.2011 | -8929502
3rd Party Creditors | 1307 | 004.2011 | -789
3rd Party Debtors | 1137 | 005.2011 | 0
3rd Party Debtors | 1032 | 005.2011 | 0
3rd Party Debtors | 1219 | 005.2011 | 122131785
3rd Party Debtors | 1281 | 005.2011 | 71118110
3rd Party Debtors | 1646 | 005.2011 | 8032395
3rd Party Debtors | 4741 | 005.2011 | 2802486
3rd Party Debtors | 1941 | 005.2011 | 572085
3rd Party Debtors | 1379 | 005.2011 | 10897727
3rd Party Debtors | 1031 | 005.2011 | 4870883
3rd Party Debtors | 1919 | 005.2011 | 7993241
3rd Party Debtors | 1330 | 005.2011 | 7782807
3rd Party Debtors | 1993 | 005.2011 | 0
3rd Party Debtors | 1993 | 005.2011 | 0
3rd Party Debtors | 3591 | 005.2011 | 0
3rd Party Debtors | 0493 | 005.2011 | 0
3rd Party Debtors | 1269 | 005.2011 | 15118856
3rd Party Debtors | 1909 | 005.2011 | 44128887
3rd Party Debtors | 4356 | 005.2011 | 2857935
3rd Party Debtors | 4357 | 005.2011 | -25553151
3rd Party Debtors | 1063 | 005.2011 | 529535
3rd Party Debtors | 3071 | 005.2011 | 21625
3rd Party Debtors | 1155 | 005.2011 | 2349000
3rd Party Debtors | 2254 | 005.2011 | 243000
3rd Party Debtors | 2997 | 005.2011 | 0
3rd Party Debtors | 1226 | 005.2011 | 2922735
3rd Party Debtors | 1227 | 005.2011 | -515
3rd Party Debtors | 1227 | 005.2011 | 70298
3rd Party Debtors | 1227 | 005.2011 | 6831943
3rd Party Debtors | 1307 | 005.2011 | 0
3rd Party Creditors | 2876 | 005.2011 | -640
3rd Party Creditors | 1137 | 005.2011 | 0
3rd Party Creditors | 1032 | 005.2011 | 0
3rd Party Creditors | 1219 | 005.2011 | -76369679
3rd Party Creditors | 1281 | 005.2011 | -5309422
3rd Party Creditors | 1646 | 005.2011 | -6601
3rd Party Creditors | 4741 | 005.2011 | -615
3rd Party Creditors | 1941 | 005.2011 | 17
3rd Party Creditors | 2039 | 005.2011 | -2469
3rd Party Creditors | 1379 | 005.2011 | -226675
3rd Party Creditors | 1031 | 005.2011 | -628254
3rd Party Creditors | 1919 | 005.2011 | -4617658
3rd Party Creditors | 1330 | 005.2011 | -4031535
3rd Party Creditors | 1330 | 005.2011 | 0
3rd Party Creditors | 1993 | 005.2011 | 0
3rd Party Creditors | 1993 | 005.2011 | 0
3rd Party Creditors | 0493 | 005.2011 | 0
3rd Party Creditors | 1269 | 005.2011 | -6319649
3rd Party Creditors | 1909 | 005.2011 | -1936818
3rd Party Creditors | 4356 | 005.2011 | -6550411
3rd Party Creditors | 4357 | 005.2011 | -25712170
3rd Party Creditors | 1063 | 005.2011 | 0
3rd Party Creditors | 3071 | 005.2011 | 3272
3rd Party Creditors | 2254 | 005.2011 | -394000
3rd Party Creditors | 2997 | 005.2011 | -461645
3rd Party Creditors | 1226 | 005.2011 | -9444
3rd Party Creditors | 1227 | 005.2011 | -6620957
3rd Party Creditors | 1307 | 005.2011 | 0
3rd Party Debtors | 1137 | 006.2011 | 0
3rd Party Debtors | 1032 | 006.2011 | 0
3rd Party Debtors | 1219 | 006.2011 | 108584398
3rd Party Debtors | 1281 | 006.2011 | 100637756
3rd Party Debtors | 1646 | 006.2011 | 7181943
3rd Party Debtors | 4741 | 006.2011 | 3719266
3rd Party Debtors | 1941 | 006.2011 | 375563
3rd Party Debtors | 1379 | 006.2011 | 13455608
3rd Party Debtors | 1031 | 006.2011 | 4910452
3rd Party Debtors | 1919 | 006.2011 | 6237356
3rd Party Debtors | 1330 | 006.2011 | 5036452
3rd Party Debtors | 1993 | 006.2011 | 0
3rd Party Debtors | 1993 | 006.2011 | 0
3rd Party Debtors | 3591 | 006.2011 | 0
3rd Party Debtors | 0493 | 006.2011 | 0
3rd Party Debtors | 1269 | 006.2011 | 19851398
3rd Party Debtors | 1909 | 006.2011 | 48413256
3rd Party Debtors | 4356 | 006.2011 | 2696414
3rd Party Debtors | 4357 | 006.2011 | -25888339
3rd Party Debtors | 1063 | 006.2011 | 522039
3rd Party Debtors | 3071 | 006.2011 | 21625
3rd Party Debtors | 1155 | 006.2011 | 2084000
3rd Party Debtors | 1862 | 006.2011 | 0
3rd Party Debtors | 2254 | 006.2011 | 980000
3rd Party Debtors | 2997 | 006.2011 | 0
3rd Party Debtors | 1226 | 006.2011 | 226684
3rd Party Debtors | 1227 | 006.2011 | 0
3rd Party Debtors | 1227 | 006.2011 | 70298
3rd Party Debtors | 1227 | 006.2011 | 7157060
3rd Party Debtors | 1307 | 006.2011 | 0
3rd Party Creditors | 2876 | 006.2011 | -614
3rd Party Creditors | 1137 | 006.2011 | -1
3rd Party Creditors | 1032 | 006.2011 | 0
3rd Party Creditors | 1219 | 006.2011 | -53046774
3rd Party Creditors | 1281 | 006.2011 | -5429751
3rd Party Creditors | 1646 | 006.2011 | 0
3rd Party Creditors | 4741 | 006.2011 | -131150
3rd Party Creditors | 1941 | 006.2011 | -4225
3rd Party Creditors | 2039 | 006.2011 | -1857
3rd Party Creditors | 1379 | 006.2011 | -462544
3rd Party Creditors | 1031 | 006.2011 | -114349
3rd Party Creditors | 1919 | 006.2011 | 3067
3rd Party Creditors | 1330 | 006.2011 | -202235
3rd Party Creditors | 1330 | 006.2011 | 0
3rd Party Creditors | 1993 | 006.2011 | 0
3rd Party Creditors | 1993 | 006.2011 | 0
3rd Party Creditors | 0493 | 006.2011 | 0
3rd Party Creditors | 1269 | 006.2011 | -6083175
3rd Party Creditors | 1909 | 006.2011 | -1702216
3rd Party Creditors | 4356 | 006.2011 | -7617703
3rd Party Creditors | 4357 | 006.2011 | -19837230
3rd Party Creditors | 1063 | 006.2011 | 0
3rd Party Creditors | 3071 | 006.2011 | 3272
3rd Party Creditors | 1155 | 006.2011 | 0
3rd Party Creditors | 1862 | 006.2011 | 0
3rd Party Creditors | 2254 | 006.2011 | -45000
3rd Party Creditors | 2997 | 006.2011 | -463
3rd Party Creditors | 1226 | 006.2011 | -29900
3rd Party Creditors | 1227 | 006.2011 | -7715128
3rd Party Creditors | 1307 | 006.2011 | -786
3rd Party Debtors | 1137 | 007.2011 | 0
3rd Party Debtors | 1032 | 007.2011 | 0
3rd Party Debtors | 1219 | 007.2011 | 106103392
3rd Party Debtors | 1281 | 007.2011 | 94936752
3rd Party Debtors | 1646 | 007.2011 | 7347572
3rd Party Debtors | 4741 | 007.2011 | 4962284
3rd Party Debtors | 1941 | 007.2011 | 694582
3rd Party Debtors | 1379 | 007.2011 | 13477979
3rd Party Debtors | 1031 | 007.2011 | 4391162
3rd Party Debtors | 1919 | 007.2011 | 5670851
3rd Party Debtors | 1330 | 007.2011 | 5736620
3rd Party Debtors | 1993 | 007.2011 | 0
3rd Party Debtors | 1993 | 007.2011 | 0
3rd Party Debtors | 3591 | 007.2011 | 0
3rd Party Debtors | 0493 | 007.2011 | 0
3rd Party Debtors | 1269 | 007.2011 | 14166991
3rd Party Debtors | 1909 | 007.2011 | 37536838
3rd Party Debtors | 4356 | 007.2011 | 2717345
3rd Party Debtors | 4357 | 007.2011 | -26172755
3rd Party Debtors | 1063 | 007.2011 | 539507
3rd Party Debtors | 3071 | 007.2011 | 21625
3rd Party Debtors | 1155 | 007.2011 | 2219000
3rd Party Debtors | 2254 | 007.2011 | 1297000
3rd Party Debtors | 2997 | 007.2011 | 0
3rd Party Debtors | 1226 | 007.2011 | 2459568
3rd Party Debtors | 1227 | 007.2011 | 0
3rd Party Debtors | 1227 | 007.2011 | 70298
3rd Party Debtors | 1227 | 007.2011 | 5729231
3rd Party Debtors | 1307 | 007.2011 | 0