JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser .
Filter values in a pivot table
Hi,
I am struggling to filter Values in this example of a pivot table.
I want to remove all channels from the pivot that are less than $100 in total not by country. i.e. when I apply the filter I should see some country channels line in this data that are less than 100 because that channel will be on another country and in total they are over 100. I have tried using value filters without success.
i have only shown part of the data there are many more rows of data for more countries.
Any ideas how I might be able to do it?
thank you
Sum of DELIVERED $ NET Country Channel Name Total Australia Comedy Central UK 1,521.88 Australia Nickelodeon UK 1,134.46 Australia Nick Jr. 1,081.84 Australia MTV International 295.19 Australia Channel Does not exist 187.16 Australia Bellator MMA 148.59 Australia Comedy Central Spain 127.82 Australia MTV Shores 88.98 Australia Nick Jr. Россия 70.41 Australia Nickelodeon Spain 31.13 Australia Total 4,687.46 Austria Nickelodeon DE 590.34 Austria Comedy Central DE 442.74 Austria MTV Germany 201.56 Austria Comedy Central UK 197.32 Austria Nickelodeon UK 138.68 Austria Nick Jr. 118.68 Austria Comedy Central Spain 35.31 Austria MTV International 31.11 Austria Nickelodeon IT 30.23 Austria Nick Jr. Россия 26.03 Austria Total 1,812.01 Brazil Nickelodeon PT 7,382.33 Brazil Nick Jr. 6,156.14 Brazil Comedy Central BR 1,022.42 Brazil Nickelodeon Spain 862.39 Brazil Nickelodeon UK 719.88 Brazil Nick Jr. Россия 688.35 Brazil Nickelodeon IT 550.23 Brazil Nickelodeon France 519.81 Brazil MTV Brasil 382.80 Brazil Nickelodeon DE 159.85 Brazil Total 18,444.20 Chile Nick Jr. 1,578.03
<tbody>
</tbody>
Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Banned - Rules violations
right click on Channel column - Value Filters (define your criteria)
or
post representative example of source data
Last edited: Jul 15, 2019
Thanks for quick reply.
however when I do that I am filtering it at the country channel level. i.e. channels for Australia that are greater than $100. I want to filter out all the channels regardless of the country that are small so less than $100. not sure if it is possible or not
Banned - Rules violations
could you post representative source data?
and what do you want to see with eg. Brazil if there is no less than 100 values?
Last edited: Jul 15, 2019
THank you, here is some data
Channel Name Country DELIVERED $ NET Comedy Central UK Poland 177.67 Nickelodeon PT Mexico 130.30 Nick Jr. Россия Thailand 117.88 Bellator MMA Brazil 129.00 Nickelodeon DE Switzerland 463.98 Nickelodeon France Russia 97.26 Nick Jr. Россия Poland 158.80 MTV IT Indonesia 83.18 Nick Jr. Россия France 260.37 Nickelodeon PT Chile 177.84 Nick Jr. Hong Kong 243.79 Comedy Central Spain Mexico 103.13 Comedy Central Spain Indonesia 75.63 MTV International Malaysia 98.66 Nick Jr. Россия Mexico 98.80 Bellator MMA Malaysia 97.22 Nickelodeon France Malaysia 96.58 Nickelodeon PT Russia 76.03 Channel Does not exist United Kingdom 311.35 Nickelodeon IT Russia 74.25 MTV Shores United Kingdom 303.19 Comedy Central UK Brazil 90.89 Nickelodeon IT France 209.21 Comedy Central UK Switzerland 315.18 Nickelodeon France Thailand 77.72 MTV Shores Indonesia 61.41 MTV FR France 191.35 Nickelodeon UK Hong Kong 188.44 Bellator MMA Thailand 72.50 MTV Germany Austria 201.56 Comedy Central DE Switzerland 283.39 Comedy Central UK Austria 197.32 MTV International Australia 295.19 Nickelodeon DE Russia 59.04 Nickelodeon Spain France 175.21 Comedy Central UK Mexico 72.70 Nickelodeon Spain Malaysia 68.66 MTV Germany Switzerland 238.68 Big Brother UK Indonesia 46.02 Nickelodeon Spain Poland 82.33 Nick Jr. Switzerland 220.57 Nick Jr. Россия Malaysia 58.57 Nickelodeon France Chile 92.58 MTV International Russia 42.85 Nickelodeon France Mexico 54.40 Nickelodeon UK Austria 138.68 Nickelodeon IT Thailand 48.85 Nickelodeon IT Mexico 53.81 Nick Jr. Россия United Kingdom 172.79 Channel Does not exist Malaysia 52.79 Comedy Central Spain Russia 41.73 Nickelodeon PT Malaysia 52.59 Nickelodeon Spain Thailand 47.87 Comedy Central Spain Malaysia 49.21 MTV International Sweden 128.41 Bellator MMA United Kingdom 157.21 Nickelodeon DE Thailand 43.99 Nickelodeon UK Switzerland 177.64 MTV IT Switzerland 175.57 Nickelodeon IT Malaysia 47.16 Bellator MMA France 113.32 Nickelodeon IT Chile 77.13 MTV PL Malaysia 46.49 Nick Jr. Austria 118.68 Comedy Central UK Chile 72.36 MTV International Thailand 39.82 Nickelodeon PT Thailand 38.42 Nickelodeon Россия Brazil 41.07 MTV Shores Brazil 39.89 Bellator MMA Australia 148.59 Nickelodeon Россия Indonesia 29.06 MTV PL Thailand 34.56 Nickelodeon PT France 88.12 Comedy Central Spain Brazil 35.70 MTV International Poland 47.47 Nickelodeon IT Switzerland 128.80 MTV Portugal Indonesia 25.31 Nickelodeon Spain United Kingdom 108.09 Nickelodeon DE Malaysia 33.00 Comedy Central Spain Australia 127.82 Comedy Central Spain United Kingdom 106.28 MTV International France 77.20 Nickelodeon France Poland 43.96 Nickelodeon IT Poland 42.80 MTV International Brazil 31.61 Comedy Central Spain Sweden 81.23 Nickelodeon DE Poland 41.59 Comedy Central Spain Thailand 27.45 Nickelodeon IT United Kingdom 96.98 Comedy Central Spain France 71.21 Nickelodeon France Switzerland 109.49 Game One France 67.95 Channel Does not exist Australia 109.91 Bellator MMA Sweden 73.43 Comedy Central Spain Poland 37.40 Comedy Central Spain Germany 73.47 Bellator MMA Poland 36.06 Nickelodeon DE France 61.03 MTV Shores France 60.51 Nickelodeon PT Poland 34.15 Comedy Central Spain Chile 40.57 Nickelodeon France United Kingdom 80.09 Channel Does not exist United Kingdom 79.59 Nickelodeon DE Chile 39.98 Nick Jr. Россия Sweden 64.10 MTV Shores Australia 88.98 Nickelodeon NL Brazil 22.25 MTV International Germany 60.50 Channel Does not exist Australia 77.25 Bellator MMA Hong Kong 46.84 MTV International Hong Kong 45.20 MTV PL Russia 14.91 Nickelodeon PT United Kingdom 61.17 Channel Does not exist Sweden 49.47 Nickelodeon DE Mexico 18.39 Nick Jr. Россия Australia 70.41 Nickelodeon Spain Sweden 47.83 Nickelodeon France Sweden 47.25 Big Brother UK United Kingdom 57.76 Bellator MMA Germany 48.81 MTV Shores Poland 23.96 Nickelodeon DE United Kingdom 52.14 MTV Shores Malaysia 15.67 Channel Does not exist Thailand 14.10 Nickelodeon IT Sweden 40.64 MTV IT Malaysia 14.62 MTV FR Malaysia 14.60 MTV IT France 33.89 Nickelodeon DE Sweden 36.84 Comedy Central Spain Austria 35.31 MTV IT Thailand 12.27 MTVLA Brazil 13.34 MTV International Mexico 12.86 Nickelodeon Россия Thailand 11.31 Bellator MMA Mexico 12.31 MTV International Austria 31.11 Nick Jr. Россия Hong Kong 28.39 MTV International Switzerland 43.22 Nickelodeon IT Austria 30.23 MTV Portugal Mexico 11.41 Big Brother UK Malaysia 11.17 Nickelodeon NL Indonesia 8.36 Nickelodeon PT Sweden 28.83 MTV Shores Sweden 28.03 Nick Jr. Россия Switzerland 39.02 Bellator MMA Chile 16.76 Nickelodeon Spain Switzerland 37.35 Nick Jr. Россия Austria 26.03 Comedy Central Spain Switzerland 37.04 MTV International Chile 16.42 MTV Asia Indonesia 7.41 MTV FR Thailand 8.74 Channel Does not exist France 22.35 Nickelodeon Spain Austria 24.17 Channel Does not exist Russia 7.27 Bellator MMA Austria 23.40 MTV PL Brazil 8.99 MTV IT Russia 6.99 MTVLA Indonesia 6.68 Nickelodeon Россия Malaysia 8.72 MTV FR Russia 6.88 Nickelodeon NL Russia 6.78 Nickelodeon NL France 20.42 Nickelodeon France Austria 22.01 Nickelodeon PT Switzerland 30.28 MTV IT Germany 22.48 Nickelodeon Spain Australia 31.13 MTV IT Brazil 8.08 Nickelodeon Россия France 19.11 MTV FR Mexico 8.04 Nickelodeon Россия Poland 10.62 Big Brother UK Thailand 7.04 Bellator MMA Switzerland 27.87 Channel Does not exist Sweden 19.24 MTV Shores Germany 19.90 Nickelodeon France Australia 27.69 Channel Does not exist Brazil 6.90 MTV Shores Thailand 6.12 Comedy Central Spain Hong Kong 15.75 MTV Shores Russia 5.03 Channel 5 United Kingdom 20.37 Nickelodeon France Hong Kong 14.73 MTV FR Brazil 6.24 MTV PL France 14.73 Nickelodeon Россия Chile 10.05 Nickelodeon IT Australia 23.70 Channel Does not exist Germany 16.92 MTV IT United Kingdom 19.38 MTV Asia Thailand 5.38 MTV Shores Switzerland 21.30 Nickelodeon PT Austria 14.78 MTV PL United Kingdom 18.05 MTV IT Poland 7.50 MTVLA France 13.15 MTV PL Germany 15.02 MTV NL Indonesia 4.11 Comedy Central BR Australia 20.86 Channel Does not exist Hong Kong 12.73 Nickelodeon DE Australia 20.75 Nickelodeon PT Australia 20.67 MTV Portugal Chile 8.62 MTV AU United Kingdom 16.59 Nickelodeon Россия Mexico 4.90 MTV FR Switzerland 17.72 Nickelodeon Spain Hong Kong 11.30 Nickelodeon DE Hong Kong 11.14 Comedy Central BR United Kingdom 14.80 MTV Asia Malaysia 4.49 #N/A Russia 3.50 MTV NL Thailand 3.99 MTV FR Poland 5.92 Comedy Central BR France 10.30 Channel Does not exist Poland 5.79 MTV Portugal Thailand 3.80 Nickelodeon Россия United Kingdom 13.40 J-One France 9.57 Channel Does not exist Malaysia 3.79 Nickelodeon IT Hong Kong 8.98 Nickelodeon NL Thailand 3.40 Channel Does not exist Switzerland 13.47 Nickelodeon NL Mexico 3.65 MTV PL Sweden 9.59 MTV NL France 8.62 Nickelodeon PT Hong Kong 8.49 Nickelodeon NL Sweden 9.29 Big Brother UK Russia 2.75 Nickelodeon NL Malaysia 3.31 MTVLA Russia 2.56 MTV Portugal Malaysia 3.22 MTV FR United Kingdom 10.26 MTV Shores Austria 7.85 Channel Does not exist Austria 7.84 BET Officiel France 7.22 Comedy Central BR Switzerland 10.88 MTV IT Sweden 7.46 MTVLA Sweden 7.43 Channel Does not exist Indonesia 2.08 Nickelodeon NL United Kingdom 8.82 Nickelodeon Россия Sweden 7.11 MTVLA Switzerland 9.76 MTV IT Austria 6.80 Comedy Central BR Sweden 6.92 MTV FR Germany 6.97 MTV FR Australia 9.21 MTV FR Chile 3.88 Channel Does not exist Mexico 2.37 Nickelodeon NL Chile 3.82 Channel Does not exist Thailand 2.10 MTV FR Sweden 6.01 MTV PL Mexico 2.27 MTV IT Mexico 2.26 MTV Shores Hong Kong 4.83 Game One Russia 1.60 MTV PL Austria 5.06 Comedy Central DE Thailand 1.75 MTVLA Thailand 1.74 Comedy Central BR Germany 5.19 Channel Does not exist Germany 5.19 Big Brother UK Hong Kong 4.33 Nickelodeon NL Poland 2.42 Big Brother UK Brazil 1.77 MTVLA Malaysia 1.74 Big Brother UK Australia 6.72 MTVLA United Kingdom 5.57 MTV Brasil Indonesia 1.29 MTVLA Germany 4.64 Comedy Central DE Poland 2.25 Big Brother UK France 3.92 MTV NL Germany 4.51 MTV Base Africa United Kingdom 5.11 MTV PL Hong Kong 3.68 Channel Does not exist Switzerland 5.74 Comedy Central BR Thailand 1.39 Channel Does not exist France 3.58 Nickelodeon Россия Australia 5.77 MTVLA Australia 5.69 MTV FR Austria 3.78 Nickelodeon NL Austria 3.73 Big Brother UK Poland 1.93 Nickelodeon NL Australia 5.41 Game One Indonesia 1.03 Comedy Central BR Russia 1.07 MTV PL Switzerland 5.01 MTV PL Chile 2.20 Comedy Central DE France 3.17 Nickelodeon NL Switzerland 4.91 Nickelodeon Россия Austria 3.34 Channel Does not exist Hong Kong 3.01 MTV AU Australia 4.89 Comedy Central DE Russia 1.00 MTV NL Sweden 3.30 Comedy Central BR Indonesia 0.94 VIVA.tv Russia 0.94 Comedy Central DE Indonesia 0.90 MTV PL Australia 4.46 MTV Germany Indonesia 0.87 VIVA.tv Germany 3.08 Channel Does not exist Poland 1.52 Paramount Comedy Poland 1.51 MTV IT Hong Kong 2.58 MTV Spain Mexico 1.09 MTV Asia Russia 0.84 Comedy Central NL Thailand 0.97 Channel Does not exist Austria 2.70 MTV IT Chile 1.70 Channel Does not exist Chile 1.64 MTV Asia Hong Kong 2.37 Comedy Central BR Poland 1.37 MTV NL Austria 2.56 MTV Portugal Brazil 0.98 Comedy Central Italia Switzerland 3.60 Big Brother UK Sweden 2.54 Game One Thailand 0.88 MTV NL United Kingdom 3.09 Comedy Central NL Indonesia 0.72 MTV Spain Chile 1.54 MTV IT Australia 3.61 MTV FR Hong Kong 2.12 Big Brother UK Germany 2.38 Comedy Central BR Malaysia 0.84 MTVLA Poland 1.15 MTV Portugal Poland 1.13 Game One Switzerland 3.03 MTV Portugal France 1.91 MTV Base Africa Malaysia 0.78 Nickelodeon Россия Hong Kong 1.84 MTV NL Russia 0.61 MTV AU Indonesia 0.57 J-One Indonesia 0.56 MTV NL Malaysia 0.73 Comedy Central DE Sweden 1.94 Comedy Central BR Austria 1.88 Nickelodeon Россия Switzerland 2.66 MTV NL Australia 2.62 MTVLA Austria 1.75 Game One Mexico 0.68 MTV Brasil France 1.60 Game One Sweden 1.64 Game One Poland 0.83 Comedy Central DE Australia 2.24 Big Brother UK Mexico 0.57 MTV Germany Poland 0.76 MTV AU Sweden 1.47 Comedy Central DE United Kingdom 1.81 Comedy Central BR Mexico 0.55 MTV NL Poland 0.75 Comedy Central NL Germany 1.50 MTV ZA Indonesia 0.41 MTV NL Switzerland 1.98 Channel 5 Indonesia 0.39 Comedy Central Italia France 1.20 MTV Brasil Switzerland 1.85 MTV Base Africa Russia 0.38 Spike NL Indonesia 0.36 Game One Malaysia 0.48 Channel Does not exist Russia 0.38 Comedy Central NL Sweden 1.27 Game One United Kingdom 1.56 Channel 5 Australia 1.83 Comedy Central BR Chile 0.76 Comedy Central BR Hong Kong 1.09 Game One Chile 0.74 Spike NL France 1.08 Paramount Network International Indonesia 0.32 MTV Portugal Russia 0.33 MTV Brasil Malaysia 0.41 Paramount Comedy Thailand 0.38 Big Brother UK Chile 0.67 Comedy Central NL France 0.98 MTV Germany Russia 0.32 Comedy Central NL United Kingdom 1.33 MTV Portugal Hong Kong 0.95 MTV Base Africa France 0.95 Game One Germany 1.03 MTV Portugal Sweden 0.99 MTV Base Africa Indonesia 0.27 Comedy Central Italia United Kingdom 1.15 Comedy Central NL Austria 0.90 Game One Australia 1.31 MTVLA Hong Kong 0.80 MTV Germany France 0.79 Nickelodeon NL Hong Kong 0.79 MTV Germany Malaysia 0.33 MTV NL Hong Kong 0.75 Comedy Central NL Malaysia 0.32 MTV AU Malaysia 0.32 MTV Brasil Thailand 0.29 MTV Asia United Kingdom 1.03 Big Brother UK Austria 0.80 Paramount Network International Russia 0.24 Comedy Central Italia Germany 0.84 MTV Base Africa Sweden 0.80 Comedy Central DE Brazil 0.30 Comedy Central NL Poland 0.40 MTV Portugal Germany 0.78 MTV Asia Poland 0.38 MTV Brasil Russia 0.22 MTV Base Africa Australia 1.07 MTV Base Africa Germany 0.74 Big Brother UK Switzerland 0.99 Comedy Central DE Hong Kong 0.62 MTV Asia Australia 0.98 MTV AU Brazil 0.26 Comedy Central NL Switzerland 0.94 MTV AU Thailand 0.23 MTV Brasil United Kingdom 0.80 VIVA.tv Austria 0.62 Comedy Central NL Russia 0.19 MTV Portugal United Kingdom 0.78 MTV Brasil Australia 0.90 MTV Portugal Switzerland 0.86 Game One Austria 0.58 MTV AU France 0.54 Comedy Central DE Malaysia 0.22 VIVA.tv Poland 0.31 MTV AU Poland 0.31 Channel 5 Thailand 0.21 Comedy Central Italia Thailand 0.21 Game One Brazil 0.22 Paramount Comedy Germany 0.60 MTV AU Germany 0.60 MTV Brasil Mexico 0.21 Game One Hong Kong 0.47 Channel 5 Malaysia 0.20 MTV NL Brazil 0.19 Comedy Central NL Hong Kong 0.45 MTV Brasil Chile 0.30 Paramount Comedy Indonesia 0.14 Comedy Central Italia Poland 0.25 Channel 5 Russia 0.14 J-One Malaysia 0.18 Comedy Central Italia Russia 0.13 Paramount Network International Chile 0.27 MTV Germany United Kingdom 0.53 Comedy Central NL Australia 0.60 MTV Portugal Austria 0.40 Paramount Comedy France 0.37 Paramount Network International Mexico 0.16 VIVA.tv Switzerland 0.57 MTV Germany Thailand 0.14 MTV Asia France 0.35 Spike NL Germany 0.39 Channel Does not exist Mexico 0.14 MTV Asia Sweden 0.37 MTV Base Africa Austria 0.35 MTV Brasil Sweden 0.35 MTV Base Africa Thailand 0.12 Neighbours TV United Kingdom 0.44 MTV Portugal Australia 0.49 MTV Asia Brazil 0.13 Comedy Central Italia Australia 0.46 MTV Brasil Germany 0.33 J-One Switzerland 0.44 Comedy Central Italia Austria 0.29 MTV Spain Brazil 0.11 MTV ZA Malaysia 0.11 Spike NL Russia 0.09 Channel 5 Sweden 0.30 MTV Germany Australia 0.41 Paramount Comedy Austria 0.27 MTV AU Austria 0.27 Channel 5 France 0.25 MTV Asia Germany 0.29 Comedy Central Italia Indonesia 0.08 MTV NL Mexico 0.11 MTV AU Russia 0.08 Paramount Comedy United Kingdom 0.34 Comedy Central DE Chile 0.16 MTV Base Africa Hong Kong 0.23 Comedy Central DE Mexico 0.10 BET Officiel United Kingdom 0.32 Spike NL Austria 0.24 Paramount Network International Brazil 0.09 Paramount Network International France 0.22 Comedy Central Italia Sweden 0.24 MTV AU Switzerland 0.34
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Banned - Rules violations
you didn't show what you want to achieve but maybe:
Country Channel Name Sum of DELIVERED $ NET Australia Big Brother UK 6.72
Channel 5 1.83
Comedy Central BR 20.86
Comedy Central DE 2.24
Comedy Central Italia 0.46
Comedy Central NL 0.6
Game One 1.31
MTV Asia 0.98
MTV AU 4.89
MTV Base Africa 1.07
MTV Brasil 0.9
MTV FR 9.21
MTV Germany 0.41
MTV IT 3.61
MTV NL 2.62
MTV PL 4.46
MTV Portugal 0.49
MTV Shores 88.98
MTVLA 5.69
Nick Jr. ?????? 70.41
Nickelodeon DE 20.75
Nickelodeon France 27.69
Nickelodeon IT 23.7
Nickelodeon NL 5.41
Nickelodeon PT 20.67
Nickelodeon Spain 31.13
Nickelodeon ?????? 5.77
Austria Bellator MMA 23.4
Big Brother UK 0.8
Channel Does not exist 10.54
Comedy Central BR 1.88
Comedy Central Italia 0.29
Comedy Central NL 0.9
Comedy Central Spain 35.31
Game One 0.58
MTV AU 0.27
MTV Base Africa 0.35
MTV FR 3.78
MTV International 31.11
MTV IT 6.8
MTV NL 2.56
MTV PL 5.06
MTV Portugal 0.4
MTV Shores 7.85
MTVLA 1.75
Nick Jr. ?????? 26.03
Nickelodeon France 22.01
Nickelodeon IT 30.23
Nickelodeon NL 3.73
Nickelodeon PT 14.78
Nickelodeon Spain 24.17
Nickelodeon ?????? 3.34
Paramount Comedy 0.27
Spike NL 0.24
VIVA.tv 0.62
Brazil Big Brother UK 1.77
Channel Does not exist 6.9
Comedy Central DE 0.3
Comedy Central Spain 35.7
Comedy Central UK 90.89
Game One 0.22
MTV Asia 0.13
MTV AU 0.26
MTV FR 6.24
MTV International 31.61
MTV IT 8.08
MTV NL 0.19
MTV PL 8.99
MTV Portugal 0.98
MTV Shores 39.89
MTV Spain 0.11
MTVLA 13.34
Nickelodeon NL 22.25
Nickelodeon ?????? 41.07
Paramount Network International 0.09
Chile Bellator MMA 16.76
Big Brother UK 0.67
Channel Does not exist 1.64
Comedy Central BR 0.76
Comedy Central DE 0.16
Comedy Central Spain 40.57
Comedy Central UK 72.36
Game One 0.74
MTV Brasil 0.3
MTV FR 3.88
MTV International 16.42
MTV IT 1.7
MTV PL 2.2
MTV Portugal 8.62
MTV Spain 1.54
Nickelodeon DE 39.98
Nickelodeon France 92.58
Nickelodeon IT 77.13
Nickelodeon NL 3.82
Nickelodeon ?????? 10.05
Paramount Network International 0.27
France BET Officiel 7.22
Big Brother UK 3.92
Channel 5 0.25
Channel Does not exist 25.93
Comedy Central BR 10.3
Comedy Central DE 3.17
Comedy Central Italia 1.2
Comedy Central NL 0.98
Comedy Central Spain 71.21
Game One 67.95
J-One 9.57
MTV Asia 0.35
MTV AU 0.54
MTV Base Africa 0.95
MTV Brasil 1.6
MTV Germany 0.79
MTV International 77.2
MTV IT 33.89
MTV NL 8.62
MTV PL 14.73
MTV Portugal 1.91
MTV Shores 60.51
MTVLA 13.15
Nickelodeon DE 61.03
Nickelodeon NL 20.42
Nickelodeon PT 88.12
Nickelodeon ?????? 19.11
Paramount Comedy 0.37
Paramount Network International 0.22
Spike NL 1.08
Germany Bellator MMA 48.81
Big Brother UK 2.38
Channel Does not exist 22.11
Comedy Central BR 5.19
Comedy Central Italia 0.84
Comedy Central NL 1.5
Comedy Central Spain 73.47
Game One 1.03
MTV Asia 0.29
MTV AU 0.6
MTV Base Africa 0.74
MTV Brasil 0.33
MTV FR 6.97
MTV International 60.5
MTV IT 22.48
MTV NL 4.51
MTV PL 15.02
MTV Portugal 0.78
MTV Shores 19.9
MTVLA 4.64
Paramount Comedy 0.6
Spike NL 0.39
VIVA.tv 3.08
Hong Kong Bellator MMA 46.84
Big Brother UK 4.33
Channel Does not exist 15.74
Comedy Central BR 1.09
Comedy Central DE 0.62
Comedy Central NL 0.45
Comedy Central Spain 15.75
Game One 0.47
MTV Asia 2.37
MTV Base Africa 0.23
MTV FR 2.12
MTV International 45.2
MTV IT 2.58
MTV NL 0.75
MTV PL 3.68
MTV Portugal 0.95
MTV Shores 4.83
MTVLA 0.8
Nick Jr. ?????? 28.39
Nickelodeon DE 11.14
Nickelodeon France 14.73
Nickelodeon IT 8.98
Nickelodeon NL 0.79
Nickelodeon PT 8.49
Nickelodeon Spain 11.3
Nickelodeon ?????? 1.84
Indonesia Big Brother UK 46.02
Channel 5 0.39
Channel Does not exist 2.08
Comedy Central BR 0.94
Comedy Central DE 0.9
Comedy Central Italia 0.08
Comedy Central NL 0.72
Comedy Central Spain 75.63
Game One 1.03
J-One 0.56
MTV Asia 7.41
MTV AU 0.57
MTV Base Africa 0.27
MTV Brasil 1.29
MTV Germany 0.87
MTV IT 83.18
MTV NL 4.11
MTV Portugal 25.31
MTV Shores 61.41
MTV ZA 0.41
MTVLA 6.68
Nickelodeon NL 8.36
Nickelodeon ?????? 29.06
Paramount Comedy 0.14
Paramount Network International 0.32
Spike NL 0.36
Malaysia Bellator MMA 97.22
Big Brother UK 11.17
Channel 5 0.2
Channel Does not exist 56.58
Comedy Central BR 0.84
Comedy Central DE 0.22
Comedy Central NL 0.32
Comedy Central Spain 49.21
Game One 0.48
J-One 0.18
MTV Asia 4.49
MTV AU 0.32
MTV Base Africa 0.78
MTV Brasil 0.41
MTV FR 14.6
MTV Germany 0.33
MTV International 98.66
MTV IT 14.62
MTV NL 0.73
MTV PL 46.49
MTV Portugal 3.22
MTV Shores 15.67
MTV ZA 0.11
MTVLA 1.74
Nick Jr. ?????? 58.57
Nickelodeon DE 33
Nickelodeon France 96.58
Nickelodeon IT 47.16
Nickelodeon NL 3.31
Nickelodeon PT 52.59
Nickelodeon Spain 68.66
Nickelodeon ?????? 8.72
Mexico Bellator MMA 12.31
Big Brother UK 0.57
Channel Does not exist 2.51
Comedy Central BR 0.55
Comedy Central DE 0.1
Comedy Central UK 72.7
Game One 0.68
MTV Brasil 0.21
MTV FR 8.04
MTV International 12.86
MTV IT 2.26
MTV NL 0.11
MTV PL 2.27
MTV Portugal 11.41
MTV Spain 1.09
Nick Jr. ?????? 98.8
Nickelodeon DE 18.39
Nickelodeon France 54.4
Nickelodeon IT 53.81
Nickelodeon NL 3.65
Nickelodeon ?????? 4.9
Paramount Network International 0.16
Poland Bellator MMA 36.06
Big Brother UK 1.93
Channel Does not exist 7.31
Comedy Central BR 1.37
Comedy Central DE 2.25
Comedy Central Italia 0.25
Comedy Central NL 0.4
Comedy Central Spain 37.4
Game One 0.83
MTV Asia 0.38
MTV AU 0.31
MTV FR 5.92
MTV Germany 0.76
MTV International 47.47
MTV IT 7.5
MTV NL 0.75
MTV Portugal 1.13
MTV Shores 23.96
MTVLA 1.15
Nickelodeon DE 41.59
Nickelodeon France 43.96
Nickelodeon IT 42.8
Nickelodeon NL 2.42
Nickelodeon PT 34.15
Nickelodeon Spain 82.33
Nickelodeon ?????? 10.62
Paramount Comedy 1.51
VIVA.tv 0.31
Russia Big Brother UK 2.75
Channel 5 0.14
Channel Does not exist 7.65
Comedy Central BR 1.07
Comedy Central DE 1
Comedy Central Italia 0.13
Comedy Central NL 0.19
Comedy Central Spain 41.73
Game One 1.6
MTV Asia 0.84
MTV AU 0.08
MTV Base Africa 0.38
MTV Brasil 0.22
MTV FR 6.88
MTV Germany 0.32
MTV International 42.85
MTV IT 6.99
MTV NL 0.61
MTV PL 14.91
MTV Portugal 0.33
MTV Shores 5.03
MTVLA 2.56
Nickelodeon DE 59.04
Nickelodeon France 97.26
Nickelodeon IT 74.25
Nickelodeon NL 6.78
Nickelodeon PT 76.03
Paramount Network International 0.24
Spike NL 0.09
VIVA.tv 0.94
#N/A 3.5
Sweden Bellator MMA 73.43
Big Brother UK 2.54
Channel 5 0.3
Channel Does not exist 68.71
Comedy Central BR 6.92
Comedy Central DE 1.94
Comedy Central Italia 0.24
Comedy Central NL 1.27
Comedy Central Spain 81.23
Game One 1.64
MTV Asia 0.37
MTV AU 1.47
MTV Base Africa 0.8
MTV Brasil 0.35
MTV FR 6.01
MTV IT 7.46
MTV NL 3.3
MTV PL 9.59
MTV Portugal 0.99
MTV Shores 28.03
MTVLA 7.43
Nick Jr. ?????? 64.1
Nickelodeon DE 36.84
Nickelodeon France 47.25
Nickelodeon IT 40.64
Nickelodeon NL 9.29
Nickelodeon PT 28.83
Nickelodeon Spain 47.83
Nickelodeon ?????? 7.11
Switzerland Bellator MMA 27.87
Big Brother UK 0.99
Channel Does not exist 19.21
Comedy Central BR 10.88
Comedy Central Italia 3.6
Comedy Central NL 0.94
Comedy Central Spain 37.04
Game One 3.03
J-One 0.44
MTV AU 0.34
MTV Brasil 1.85
MTV FR 17.72
MTV International 43.22
MTV NL 1.98
MTV PL 5.01
MTV Portugal 0.86
MTV Shores 21.3
MTVLA 9.76
Nick Jr. ?????? 39.02
Nickelodeon NL 4.91
Nickelodeon PT 30.28
Nickelodeon Spain 37.35
Nickelodeon ?????? 2.66
VIVA.tv 0.57
Thailand Bellator MMA 72.5
Big Brother UK 7.04
Channel 5 0.21
Channel Does not exist 16.2
Comedy Central BR 1.39
Comedy Central DE 1.75
Comedy Central Italia 0.21
Comedy Central NL 0.97
Comedy Central Spain 27.45
Game One 0.88
MTV Asia 5.38
MTV AU 0.23
MTV Base Africa 0.12
MTV Brasil 0.29
MTV FR 8.74
MTV Germany 0.14
MTV International 39.82
MTV IT 12.27
MTV NL 3.99
MTV PL 34.56
MTV Portugal 3.8
MTV Shores 6.12
MTVLA 1.74
Nickelodeon DE 43.99
Nickelodeon France 77.72
Nickelodeon IT 48.85
Nickelodeon NL 3.4
Nickelodeon PT 38.42
Nickelodeon Spain 47.87
Nickelodeon ?????? 11.31
Paramount Comedy 0.38
United Kingdom BET Officiel 0.32
Big Brother UK 57.76
Channel 5 20.37
Comedy Central BR 14.8
Comedy Central DE 1.81
Comedy Central Italia 1.15
Comedy Central NL 1.33
Game One 1.56
MTV Asia 1.03
MTV AU 16.59
MTV Base Africa 5.11
MTV Brasil 0.8
MTV FR 10.26
MTV Germany 0.53
MTV IT 19.38
MTV NL 3.09
MTV PL 18.05
MTV Portugal 0.78
MTVLA 5.57
Neighbours TV 0.44
Nickelodeon DE 52.14
Nickelodeon France 80.09
Nickelodeon IT 96.98
Nickelodeon NL 8.82
Nickelodeon PT 61.17
Nickelodeon ?????? 13.4
Paramount Comedy 0.34
with filter Values less than 100
I want to see a pivot of channel, country & Delivered net. but and here is the tricky thing i want to filter out all the channels where total is greater than 100. So not where channel country is greater than 100 but where the channel total is greater than 100 and then see the split by channel country.
I would do this in the data source but it is too difficult likewise i could filter the channel list based on another pivot of just channel but I want this to work dynamically as a template for similar data.
thanks
Banned - Rules violations
to be sure: greater than 100 or less than 100? (post#1)
for greater than 100
Country Channel Name Delivered & Net Australia Nickelodeon PT 761.67
Australia Nickelodeon DE 881.87
Australia MTV Shores 686.67
Australia Comedy Central DE 299.85
Australia Nickelodeon France 763.76
Australia MTV Germany 444.39
Australia Nickelodeon ?????? 168.96
Australia Bellator MMA 1003.32
Australia Nick Jr. ?????? 1095.16
Australia MTV PL 185.02
Australia Nickelodeon IT 882.54
Australia Big Brother UK 151.36
Australia Nickelodeon Spain 633.94
Australia Nickelodeon NL 107.36
Australia Comedy Central Spain 958.93
Australia Channel Does not exist 841.21
Australia MTV FR 301.72
Australia MTV International 970.52
Australia MTV IT 408.37
Austria Big Brother UK 151.36
Austria Comedy Central Spain 958.93
Austria MTV Germany 444.39
Austria Bellator MMA 1003.32
Austria Nickelodeon IT 882.54
Austria Channel Does not exist 841.21
Austria Nickelodeon France 763.76
Austria MTV IT 408.37
Austria Nick Jr. 583.04
Austria Nickelodeon Spain 633.94
Austria MTV PL 185.02
Austria MTV International 970.52
Austria Nickelodeon NL 107.36
Austria Nick Jr. ?????? 1095.16
Austria Nickelodeon ?????? 168.96
Austria Nickelodeon UK 504.76
Austria MTV Shores 686.67
Austria MTV FR 301.72
Austria Nickelodeon PT 761.67
Austria Comedy Central UK 926.12
Brazil Comedy Central DE 299.85
Brazil Nickelodeon ?????? 168.96
Brazil MTV PL 185.02
Brazil Channel Does not exist 841.21
Brazil MTV IT 408.37
Brazil Nickelodeon NL 107.36
Brazil Bellator MMA 1003.32
Brazil Comedy Central Spain 958.93
Brazil MTV FR 301.72
Brazil Comedy Central UK 926.12
Brazil MTV Shores 686.67
Brazil MTV International 970.52
Brazil Big Brother UK 151.36
Chile Comedy Central Spain 958.93
Chile Comedy Central DE 299.85
Chile Comedy Central UK 926.12
Chile Nickelodeon DE 881.87
Chile MTV IT 408.37
Chile Nickelodeon PT 761.67
Chile MTV International 970.52
Chile Big Brother UK 151.36
Chile Nickelodeon NL 107.36
Chile MTV FR 301.72
Chile Nickelodeon France 763.76
Chile Channel Does not exist 841.21
Chile MTV PL 185.02
Chile Nickelodeon ?????? 168.96
Chile Bellator MMA 1003.32
Chile Nickelodeon IT 882.54
France Nickelodeon PT 761.67
France MTV Germany 444.39
France MTV FR 301.72
France Nickelodeon DE 881.87
France Comedy Central Spain 958.93
France Bellator MMA 1003.32
France MTV Shores 686.67
France MTV International 970.52
France Nickelodeon Spain 633.94
France Nickelodeon ?????? 168.96
France Nickelodeon NL 107.36
France Channel Does not exist 841.21
France MTV IT 408.37
France Nickelodeon IT 882.54
France MTV PL 185.02
France Nick Jr. ?????? 1095.16
France Big Brother UK 151.36
France Comedy Central DE 299.85
Germany Comedy Central Spain 958.93
Germany Bellator MMA 1003.32
Germany MTV PL 185.02
Germany Channel Does not exist 841.21
Germany MTV Shores 686.67
Germany Big Brother UK 151.36
Germany MTV IT 408.37
Germany MTV FR 301.72
Germany MTV International 970.52
Hong Kong Nickelodeon IT 882.54
Hong Kong MTV Shores 686.67
Hong Kong Comedy Central DE 299.85
Hong Kong MTV International 970.52
Hong Kong Nickelodeon UK 504.76
Hong Kong Channel Does not exist 841.21
Hong Kong MTV FR 301.72
Hong Kong Comedy Central Spain 958.93
Hong Kong Nickelodeon NL 107.36
Hong Kong Nick Jr. ?????? 1095.16
Hong Kong Nickelodeon ?????? 168.96
Hong Kong Nick Jr. 583.04
Hong Kong Nickelodeon France 763.76
Hong Kong MTV PL 185.02
Hong Kong MTV IT 408.37
Hong Kong Bellator MMA 1003.32
Hong Kong Big Brother UK 151.36
Hong Kong Nickelodeon Spain 633.94
Hong Kong Nickelodeon PT 761.67
Hong Kong Nickelodeon DE 881.87
Indonesia MTV IT 408.37
Indonesia Comedy Central Spain 958.93
Indonesia Nickelodeon ?????? 168.96
Indonesia Channel Does not exist 841.21
Indonesia MTV Germany 444.39
Indonesia Comedy Central DE 299.85
Indonesia MTV Shores 686.67
Indonesia Nickelodeon NL 107.36
Indonesia Big Brother UK 151.36
Malaysia Nickelodeon DE 881.87
Malaysia Nickelodeon PT 761.67
Malaysia Nick Jr. ?????? 1095.16
Malaysia MTV Germany 444.39
Malaysia Nickelodeon IT 882.54
Malaysia Nickelodeon ?????? 168.96
Malaysia Bellator MMA 1003.32
Malaysia MTV FR 301.72
Malaysia Nickelodeon NL 107.36
Malaysia MTV Shores 686.67
Malaysia MTV International 970.52
Malaysia Comedy Central Spain 958.93
Malaysia Nickelodeon France 763.76
Malaysia MTV IT 408.37
Malaysia MTV PL 185.02
Malaysia Big Brother UK 151.36
Malaysia Nickelodeon Spain 633.94
Malaysia Channel Does not exist 841.21
Malaysia Comedy Central DE 299.85
Mexico Comedy Central Spain 958.93
Mexico Nickelodeon PT 761.67
Mexico MTV International 970.52
Mexico Comedy Central DE 299.85
Mexico MTV IT 408.37
Mexico Nick Jr. ?????? 1095.16
Mexico Nickelodeon NL 107.36
Mexico Channel Does not exist 841.21
Mexico Nickelodeon France 763.76
Mexico Nickelodeon DE 881.87
Mexico Nickelodeon IT 882.54
Mexico MTV PL 185.02
Mexico Comedy Central UK 926.12
Mexico MTV FR 301.72
Mexico Nickelodeon ?????? 168.96
Mexico Bellator MMA 1003.32
Mexico Big Brother UK 151.36
Poland MTV FR 301.72
Poland Nickelodeon Spain 633.94
Poland Big Brother UK 151.36
Poland MTV Germany 444.39
Poland Nickelodeon ?????? 168.96
Poland Nickelodeon NL 107.36
Poland Comedy Central DE 299.85
Poland Nickelodeon DE 881.87
Poland Comedy Central Spain 958.93
Poland MTV Shores 686.67
Poland Nick Jr. ?????? 1095.16
Poland Nickelodeon France 763.76
Poland Channel Does not exist 841.21
Poland MTV International 970.52
Poland Comedy Central UK 926.12
Poland Bellator MMA 1003.32
Poland MTV IT 408.37
Poland Nickelodeon IT 882.54
Poland Nickelodeon PT 761.67
Russia Nickelodeon IT 882.54
Russia MTV IT 408.37
Russia Nickelodeon France 763.76
Russia MTV FR 301.72
Russia MTV International 970.52
Russia Nickelodeon DE 881.87
Russia Comedy Central DE 299.85
Russia Channel Does not exist 841.21
Russia Nickelodeon PT 761.67
Russia MTV Germany 444.39
Russia MTV PL 185.02
Russia Nickelodeon NL 107.36
Russia Comedy Central Spain 958.93
Russia Big Brother UK 151.36
Russia MTV Shores 686.67
Sweden Nickelodeon Spain 633.94
Sweden Nickelodeon France 763.76
Sweden MTV International 970.52
Sweden MTV IT 408.37
Sweden MTV PL 185.02
Sweden Nickelodeon DE 881.87
Sweden Comedy Central Spain 958.93
Sweden Nickelodeon NL 107.36
Sweden Nick Jr. ?????? 1095.16
Sweden MTV FR 301.72
Sweden Nickelodeon PT 761.67
Sweden MTV Shores 686.67
Sweden Nickelodeon IT 882.54
Sweden Nickelodeon ?????? 168.96
Sweden Channel Does not exist 841.21
Sweden Comedy Central DE 299.85
Sweden Big Brother UK 151.36
Sweden Bellator MMA 1003.32
Switzerland Comedy Central UK 926.12
Switzerland Nickelodeon NL 107.36
Switzerland MTV IT 408.37
Switzerland Bellator MMA 1003.32
Switzerland Nick Jr. ?????? 1095.16
Switzerland MTV PL 185.02
Switzerland Nickelodeon DE 881.87
Switzerland Nickelodeon PT 761.67
Switzerland Big Brother UK 151.36
Switzerland Nickelodeon ?????? 168.96
Switzerland Nickelodeon France 763.76
Switzerland MTV Germany 444.39
Switzerland Comedy Central Spain 958.93
Switzerland Nickelodeon UK 504.76
Switzerland Nickelodeon Spain 633.94
Switzerland MTV International 970.52
Switzerland Comedy Central DE 299.85
Switzerland Nickelodeon IT 882.54
Switzerland MTV FR 301.72
Switzerland Channel Does not exist 841.21
Switzerland MTV Shores 686.67
Switzerland Nick Jr. 583.04
Thailand Bellator MMA 1003.32
Thailand Nickelodeon IT 882.54
Thailand Comedy Central DE 299.85
Thailand Nickelodeon ?????? 168.96
Thailand Nick Jr. ?????? 1095.16
Thailand Nickelodeon PT 761.67
Thailand Nickelodeon NL 107.36
Thailand MTV Germany 444.39
Thailand MTV Shores 686.67
Thailand MTV FR 301.72
Thailand Comedy Central Spain 958.93
Thailand Nickelodeon France 763.76
Thailand Nickelodeon Spain 633.94
Thailand MTV IT 408.37
Thailand Big Brother UK 151.36
Thailand MTV PL 185.02
Thailand MTV International 970.52
Thailand Channel Does not exist 841.21
Thailand Nickelodeon DE 881.87
United Kingdom Nickelodeon NL 107.36
United Kingdom Nickelodeon France 763.76
United Kingdom Channel Does not exist 841.21
United Kingdom Nickelodeon PT 761.67
United Kingdom MTV FR 301.72
United Kingdom MTV IT 408.37
United Kingdom Comedy Central Spain 958.93
United Kingdom Comedy Central DE 299.85
United Kingdom Big Brother UK 151.36
United Kingdom Nick Jr. ?????? 1095.16
United Kingdom Nickelodeon Spain 633.94
United Kingdom Nickelodeon DE 881.87
United Kingdom MTV Germany 444.39
United Kingdom Nickelodeon IT 882.54
United Kingdom MTV Shores 686.67
United Kingdom Nickelodeon ?????? 168.96
United Kingdom Bellator MMA 1003.32
United Kingdom MTV PL 185.02
for less than 100
Country Channel Name Delivered & Net Australia MTV Brasil 8.55
Australia Comedy Central NL 10.57
Australia Game One 84.03
Australia Comedy Central BR 78.84
Australia Channel 5 23.69
Australia MTV AU 26.47
Australia MTV Portugal 61.96
Australia Comedy Central Italia 8.45
Australia MTV Asia 24.02
Australia MTVLA 76
Australia MTV Base Africa 10.8
Australia MTV NL 37.92
Austria MTV AU 26.47
Austria VIVA.tv 5.52
Austria Game One 84.03
Austria MTV Base Africa 10.8
Austria Comedy Central NL 10.57
Austria MTVLA 76
Austria Paramount Comedy 3.61
Austria Comedy Central Italia 8.45
Austria MTV NL 37.92
Austria Spike NL 2.16
Austria MTV Portugal 61.96
Austria Comedy Central BR 78.84
Brazil Game One 84.03
Brazil MTV Spain 2.74
Brazil MTV Portugal 61.96
Brazil MTVLA 76
Brazil MTV NL 37.92
Brazil MTV AU 26.47
Brazil Paramount Network International 1.3
Brazil MTV Asia 24.02
Chile Paramount Network International 1.3
Chile MTV Portugal 61.96
Chile MTV Spain 2.74
Chile Comedy Central BR 78.84
Chile Game One 84.03
Chile MTV Brasil 8.55
France J-One 10.75
France MTV NL 37.92
France MTV Base Africa 10.8
France BET Officiel 7.54
France MTV Asia 24.02
France MTV Brasil 8.55
France Channel 5 23.69
France MTVLA 76
France Spike NL 2.16
France Comedy Central BR 78.84
France Comedy Central Italia 8.45
France Game One 84.03
France Comedy Central NL 10.57
France MTV AU 26.47
France MTV Portugal 61.96
France Paramount Network International 1.3
France Paramount Comedy 3.61
Germany MTV Brasil 8.55
Germany MTV Portugal 61.96
Germany Comedy Central BR 78.84
Germany Spike NL 2.16
Germany MTV NL 37.92
Germany VIVA.tv 5.52
Germany MTV AU 26.47
Germany Paramount Comedy 3.61
Germany MTVLA 76
Germany MTV Base Africa 10.8
Germany Comedy Central Italia 8.45
Germany MTV Asia 24.02
Germany Game One 84.03
Germany Comedy Central NL 10.57
Hong Kong MTV NL 37.92
Hong Kong Comedy Central BR 78.84
Hong Kong MTVLA 76
Hong Kong Comedy Central NL 10.57
Hong Kong MTV Portugal 61.96
Hong Kong MTV Base Africa 10.8
Hong Kong Game One 84.03
Hong Kong MTV Asia 24.02
Indonesia MTV ZA 0.52
Indonesia Spike NL 2.16
Indonesia MTV Portugal 61.96
Indonesia Comedy Central BR 78.84
Indonesia Paramount Network International 1.3
Indonesia Comedy Central Italia 8.45
Indonesia Paramount Comedy 3.61
Indonesia MTV Base Africa 10.8
Indonesia MTV Brasil 8.55
Indonesia MTV AU 26.47
Indonesia J-One 10.75
Indonesia Comedy Central NL 10.57
Indonesia MTVLA 76
Indonesia Game One 84.03
Indonesia Channel 5 23.69
Indonesia MTV Asia 24.02
Indonesia MTV NL 37.92
Malaysia MTV NL 37.92
Malaysia MTV Asia 24.02
Malaysia Channel 5 23.69
Malaysia MTVLA 76
Malaysia MTV Brasil 8.55
Malaysia Comedy Central NL 10.57
Malaysia J-One 10.75
Malaysia Game One 84.03
Malaysia MTV ZA 0.52
Malaysia MTV Base Africa 10.8
Malaysia MTV Portugal 61.96
Malaysia MTV AU 26.47
Malaysia Comedy Central BR 78.84
Mexico Paramount Network International 1.3
Mexico MTV Spain 2.74
Mexico Comedy Central BR 78.84
Mexico MTV Portugal 61.96
Mexico MTV Brasil 8.55
Mexico MTV NL 37.92
Mexico Game One 84.03
Poland MTV Asia 24.02
Poland VIVA.tv 5.52
Poland MTVLA 76
Poland Paramount Comedy 3.61
Poland MTV NL 37.92
Poland MTV AU 26.47
Poland Comedy Central BR 78.84
Poland MTV Portugal 61.96
Poland Comedy Central Italia 8.45
Poland Game One 84.03
Poland Comedy Central NL 10.57
Russia Paramount Network International 1.3
Russia Comedy Central BR 78.84
Russia VIVA.tv 5.52
Russia Comedy Central Italia 8.45
Russia MTV Asia 24.02
Russia MTVLA 76
Russia Game One 84.03
Russia Spike NL 2.16
Russia Comedy Central NL 10.57
Russia MTV Portugal 61.96
Russia 3.5
Russia MTV Base Africa 10.8
Russia MTV Brasil 8.55
Russia MTV AU 26.47
Russia MTV NL 37.92
Russia Channel 5 23.69
Sweden Channel 5 23.69
Sweden MTV Asia 24.02
Sweden Comedy Central NL 10.57
Sweden MTVLA 76
Sweden Game One 84.03
Sweden MTV NL 37.92
Sweden Comedy Central BR 78.84
Sweden MTV Portugal 61.96
Sweden MTV Base Africa 10.8
Sweden MTV AU 26.47
Sweden MTV Brasil 8.55
Sweden Comedy Central Italia 8.45
Switzerland Comedy Central BR 78.84
Switzerland Comedy Central NL 10.57
Switzerland MTV NL 37.92
Switzerland J-One 10.75
Switzerland Game One 84.03
Switzerland MTV AU 26.47
Switzerland MTV Portugal 61.96
Switzerland Comedy Central Italia 8.45
Switzerland MTV Brasil 8.55
Switzerland MTVLA 76
Switzerland VIVA.tv 5.52
Thailand MTVLA 76
Thailand MTV Asia 24.02
Thailand Game One 84.03
Thailand Channel 5 23.69
Thailand Paramount Comedy 3.61
Thailand MTV AU 26.47
Thailand MTV Base Africa 10.8
Thailand MTV NL 37.92
Thailand MTV Brasil 8.55
Thailand MTV Portugal 61.96
Thailand Comedy Central BR 78.84
Thailand Comedy Central NL 10.57
Thailand Comedy Central Italia 8.45
United Kingdom Neighbours TV 0.44
United Kingdom MTV AU 26.47
United Kingdom MTV Asia 24.02
United Kingdom Channel 5 23.69
United Kingdom Comedy Central BR 78.84
United Kingdom MTV Base Africa 10.8
United Kingdom Comedy Central NL 10.57
United Kingdom Comedy Central Italia 8.45
United Kingdom Game One 84.03
United Kingdom BET Officiel 7.54
United Kingdom MTV NL 37.92
United Kingdom MTVLA 76
United Kingdom MTV Portugal 61.96
United Kingdom Paramount Comedy 3.61
United Kingdom MTV Brasil 8.55
Last edited: Jul 18, 2019
Banned - Rules violations
or with PivotTable and filter less than 100
Channel Name Country Sum of DELIVERED $ NET BET Officiel France 7.22
United Kingdom 0.32
Channel 5 Australia 1.83
France 0.25
Indonesia 0.39
Malaysia 0.2
Russia 0.14
Sweden 0.3
Thailand 0.21
United Kingdom 20.37
Comedy Central BR Australia 20.86
Austria 1.88
Chile 0.76
France 10.3
Germany 5.19
Hong Kong 1.09
Indonesia 0.94
Malaysia 0.84
Mexico 0.55
Poland 1.37
Russia 1.07
Sweden 6.92
Switzerland 10.88
Thailand 1.39
United Kingdom 14.8
Comedy Central Italia Australia 0.46
Austria 0.29
France 1.2
Germany 0.84
Indonesia 0.08
Poland 0.25
Russia 0.13
Sweden 0.24
Switzerland 3.6
Thailand 0.21
United Kingdom 1.15
Comedy Central NL Australia 0.6
Austria 0.9
France 0.98
Germany 1.5
Hong Kong 0.45
Indonesia 0.72
Malaysia 0.32
Poland 0.4
Russia 0.19
Sweden 1.27
Switzerland 0.94
Thailand 0.97
United Kingdom 1.33
Game One Australia 1.31
Austria 0.58
Brazil 0.22
Chile 0.74
France 67.95
Germany 1.03
Hong Kong 0.47
Indonesia 1.03
Malaysia 0.48
Mexico 0.68
Poland 0.83
Russia 1.6
Sweden 1.64
Switzerland 3.03
Thailand 0.88
United Kingdom 1.56
J-One France 9.57
Indonesia 0.56
Malaysia 0.18
Switzerland 0.44
MTV Asia Australia 0.98
Brazil 0.13
France 0.35
Germany 0.29
Hong Kong 2.37
Indonesia 7.41
Malaysia 4.49
Poland 0.38
Russia 0.84
Sweden 0.37
Thailand 5.38
United Kingdom 1.03
MTV AU Australia 4.89
Austria 0.27
Brazil 0.26
France 0.54
Germany 0.6
Indonesia 0.57
Malaysia 0.32
Poland 0.31
Russia 0.08
Sweden 1.47
Switzerland 0.34
Thailand 0.23
United Kingdom 16.59
MTV Base Africa Australia 1.07
Austria 0.35
France 0.95
Germany 0.74
Hong Kong 0.23
Indonesia 0.27
Malaysia 0.78
Russia 0.38
Sweden 0.8
Thailand 0.12
United Kingdom 5.11
MTV Brasil Australia 0.9
Chile 0.3
France 1.6
Germany 0.33
Indonesia 1.29
Malaysia 0.41
Mexico 0.21
Russia 0.22
Sweden 0.35
Switzerland 1.85
Thailand 0.29
United Kingdom 0.8
MTV NL Australia 2.62
Austria 2.56
Brazil 0.19
France 8.62
Germany 4.51
Hong Kong 0.75
Indonesia 4.11
Malaysia 0.73
Mexico 0.11
Poland 0.75
Russia 0.61
Sweden 3.3
Switzerland 1.98
Thailand 3.99
United Kingdom 3.09
MTV Portugal Australia 0.49
Austria 0.4
Brazil 0.98
Chile 8.62
France 1.91
Germany 0.78
Hong Kong 0.95
Indonesia 25.31
Malaysia 3.22
Mexico 11.41
Poland 1.13
Russia 0.33
Sweden 0.99
Switzerland 0.86
Thailand 3.8
United Kingdom 0.78
MTV Spain Brazil 0.11
Chile 1.54
Mexico 1.09
MTV ZA Indonesia 0.41
Malaysia 0.11
MTVLA Australia 5.69
Austria 1.75
Brazil 13.34
France 13.15
Germany 4.64
Hong Kong 0.8
Indonesia 6.68
Malaysia 1.74
Poland 1.15
Russia 2.56
Sweden 7.43
Switzerland 9.76
Thailand 1.74
United Kingdom 5.57
Neighbours TV United Kingdom 0.44
Paramount Comedy Austria 0.27
France 0.37
Germany 0.6
Indonesia 0.14
Poland 1.51
Thailand 0.38
United Kingdom 0.34
Paramount Network International Brazil 0.09
Chile 0.27
France 0.22
Indonesia 0.32
Mexico 0.16
Russia 0.24
Spike NL Austria 0.24
France 1.08
Germany 0.39
Indonesia 0.36
Russia 0.09
VIVA.tv Austria 0.62
Germany 3.08
Poland 0.31
Russia 0.94
Switzerland 0.57
#N/A Russia 3.5
Last edited: Jul 18, 2019
Thanks, how did you do it?
Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra