Filter values in a pivot table

ExGus

Board Regular
Joined
May 2, 2012
Messages
53
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
CountryChannel NameTotal
AustraliaComedy Central UK1,521.88
AustraliaNickelodeon UK1,134.46
AustraliaNick Jr.1,081.84
AustraliaMTV International295.19
AustraliaChannel Does not exist187.16
AustraliaBellator MMA148.59
AustraliaComedy Central Spain127.82
AustraliaMTV Shores88.98
AustraliaNick Jr. Россия70.41
AustraliaNickelodeon Spain31.13
Australia Total4,687.46
AustriaNickelodeon DE590.34
AustriaComedy Central DE442.74
AustriaMTV Germany201.56
AustriaComedy Central UK197.32
AustriaNickelodeon UK138.68
AustriaNick Jr.118.68
AustriaComedy Central Spain35.31
AustriaMTV International31.11
AustriaNickelodeon IT30.23
AustriaNick Jr. Россия26.03
Austria Total1,812.01
BrazilNickelodeon PT7,382.33
BrazilNick Jr.6,156.14
BrazilComedy Central BR1,022.42
BrazilNickelodeon Spain862.39
BrazilNickelodeon UK719.88
BrazilNick Jr. Россия688.35
BrazilNickelodeon IT550.23
BrazilNickelodeon France519.81
BrazilMTV Brasil382.80
BrazilNickelodeon DE159.85
Brazil Total18,444.20
ChileNick Jr.1,578.03

<tbody>
</tbody>
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
right click on Channel column - Value Filters (define your criteria)
or
post representative example of source data
 
Last edited:
Upvote 0
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
 
Upvote 0
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:
Upvote 0
THank you, here is some data


Channel NameCountryDELIVERED $ NET
Comedy Central UKPoland 177.67
Nickelodeon PTMexico 130.30
Nick Jr. РоссияThailand 117.88
Bellator MMABrazil 129.00
Nickelodeon DESwitzerland 463.98
Nickelodeon FranceRussia 97.26
Nick Jr. РоссияPoland 158.80
MTV ITIndonesia 83.18
Nick Jr. РоссияFrance 260.37
Nickelodeon PTChile 177.84
Nick Jr.Hong Kong 243.79
Comedy Central SpainMexico 103.13
Comedy Central SpainIndonesia 75.63
MTV InternationalMalaysia 98.66
Nick Jr. РоссияMexico 98.80
Bellator MMAMalaysia 97.22
Nickelodeon FranceMalaysia 96.58
Nickelodeon PTRussia 76.03
Channel Does not existUnited Kingdom 311.35
Nickelodeon ITRussia 74.25
MTV ShoresUnited Kingdom 303.19
Comedy Central UKBrazil 90.89
Nickelodeon ITFrance 209.21
Comedy Central UKSwitzerland 315.18
Nickelodeon FranceThailand 77.72
MTV ShoresIndonesia 61.41
MTV FRFrance 191.35
Nickelodeon UKHong Kong 188.44
Bellator MMAThailand 72.50
MTV GermanyAustria 201.56
Comedy Central DESwitzerland 283.39
Comedy Central UKAustria 197.32
MTV InternationalAustralia 295.19
Nickelodeon DERussia 59.04
Nickelodeon SpainFrance 175.21
Comedy Central UKMexico 72.70
Nickelodeon SpainMalaysia 68.66
MTV GermanySwitzerland 238.68
Big Brother UKIndonesia 46.02
Nickelodeon SpainPoland 82.33
Nick Jr.Switzerland 220.57
Nick Jr. РоссияMalaysia 58.57
Nickelodeon FranceChile 92.58
MTV InternationalRussia 42.85
Nickelodeon FranceMexico 54.40
Nickelodeon UKAustria 138.68
Nickelodeon ITThailand 48.85
Nickelodeon ITMexico 53.81
Nick Jr. РоссияUnited Kingdom 172.79
Channel Does not existMalaysia 52.79
Comedy Central SpainRussia 41.73
Nickelodeon PTMalaysia 52.59
Nickelodeon SpainThailand 47.87
Comedy Central SpainMalaysia 49.21
MTV InternationalSweden 128.41
Bellator MMAUnited Kingdom 157.21
Nickelodeon DEThailand 43.99
Nickelodeon UKSwitzerland 177.64
MTV ITSwitzerland 175.57
Nickelodeon ITMalaysia 47.16
Bellator MMAFrance 113.32
Nickelodeon ITChile 77.13
MTV PLMalaysia 46.49
Nick Jr.Austria 118.68
Comedy Central UKChile 72.36
MTV InternationalThailand 39.82
Nickelodeon PTThailand 38.42
Nickelodeon РоссияBrazil 41.07
MTV ShoresBrazil 39.89
Bellator MMAAustralia 148.59
Nickelodeon РоссияIndonesia 29.06
MTV PLThailand 34.56
Nickelodeon PTFrance 88.12
Comedy Central SpainBrazil 35.70
MTV InternationalPoland 47.47
Nickelodeon ITSwitzerland 128.80
MTV PortugalIndonesia 25.31
Nickelodeon SpainUnited Kingdom 108.09
Nickelodeon DEMalaysia 33.00
Comedy Central SpainAustralia 127.82
Comedy Central SpainUnited Kingdom 106.28
MTV InternationalFrance 77.20
Nickelodeon FrancePoland 43.96
Nickelodeon ITPoland 42.80
MTV InternationalBrazil 31.61
Comedy Central SpainSweden 81.23
Nickelodeon DEPoland 41.59
Comedy Central SpainThailand 27.45
Nickelodeon ITUnited Kingdom 96.98
Comedy Central SpainFrance 71.21
Nickelodeon FranceSwitzerland 109.49
Game OneFrance 67.95
Channel Does not existAustralia 109.91
Bellator MMASweden 73.43
Comedy Central SpainPoland 37.40
Comedy Central SpainGermany 73.47
Bellator MMAPoland 36.06
Nickelodeon DEFrance 61.03
MTV ShoresFrance 60.51
Nickelodeon PTPoland 34.15
Comedy Central SpainChile 40.57
Nickelodeon FranceUnited Kingdom 80.09
Channel Does not existUnited Kingdom 79.59
Nickelodeon DEChile 39.98
Nick Jr. РоссияSweden 64.10
MTV ShoresAustralia 88.98
Nickelodeon NLBrazil 22.25
MTV InternationalGermany 60.50
Channel Does not existAustralia 77.25
Bellator MMAHong Kong 46.84
MTV InternationalHong Kong 45.20
MTV PLRussia 14.91
Nickelodeon PTUnited Kingdom 61.17
Channel Does not existSweden 49.47
Nickelodeon DEMexico 18.39
Nick Jr. РоссияAustralia 70.41
Nickelodeon SpainSweden 47.83
Nickelodeon FranceSweden 47.25
Big Brother UKUnited Kingdom 57.76
Bellator MMAGermany 48.81
MTV ShoresPoland 23.96
Nickelodeon DEUnited Kingdom 52.14
MTV ShoresMalaysia 15.67
Channel Does not existThailand 14.10
Nickelodeon ITSweden 40.64
MTV ITMalaysia 14.62
MTV FRMalaysia 14.60
MTV ITFrance 33.89
Nickelodeon DESweden 36.84
Comedy Central SpainAustria 35.31
MTV ITThailand 12.27
MTVLABrazil 13.34
MTV InternationalMexico 12.86
Nickelodeon РоссияThailand 11.31
Bellator MMAMexico 12.31
MTV InternationalAustria 31.11
Nick Jr. РоссияHong Kong 28.39
MTV InternationalSwitzerland 43.22
Nickelodeon ITAustria 30.23
MTV PortugalMexico 11.41
Big Brother UKMalaysia 11.17
Nickelodeon NLIndonesia 8.36
Nickelodeon PTSweden 28.83
MTV ShoresSweden 28.03
Nick Jr. РоссияSwitzerland 39.02
Bellator MMAChile 16.76
Nickelodeon SpainSwitzerland 37.35
Nick Jr. РоссияAustria 26.03
Comedy Central SpainSwitzerland 37.04
MTV InternationalChile 16.42
MTV AsiaIndonesia 7.41
MTV FRThailand 8.74
Channel Does not existFrance 22.35
Nickelodeon SpainAustria 24.17
Channel Does not existRussia 7.27
Bellator MMAAustria 23.40
MTV PLBrazil 8.99
MTV ITRussia 6.99
MTVLAIndonesia 6.68
Nickelodeon РоссияMalaysia 8.72
MTV FRRussia 6.88
Nickelodeon NLRussia 6.78
Nickelodeon NLFrance 20.42
Nickelodeon FranceAustria 22.01
Nickelodeon PTSwitzerland 30.28
MTV ITGermany 22.48
Nickelodeon SpainAustralia 31.13
MTV ITBrazil 8.08
Nickelodeon РоссияFrance 19.11
MTV FRMexico 8.04
Nickelodeon РоссияPoland 10.62
Big Brother UKThailand 7.04
Bellator MMASwitzerland 27.87
Channel Does not existSweden 19.24
MTV ShoresGermany 19.90
Nickelodeon FranceAustralia 27.69
Channel Does not existBrazil 6.90
MTV ShoresThailand 6.12
Comedy Central SpainHong Kong 15.75
MTV ShoresRussia 5.03
Channel 5United Kingdom 20.37
Nickelodeon FranceHong Kong 14.73
MTV FRBrazil 6.24
MTV PLFrance 14.73
Nickelodeon РоссияChile 10.05
Nickelodeon ITAustralia 23.70
Channel Does not existGermany 16.92
MTV ITUnited Kingdom 19.38
MTV AsiaThailand 5.38
MTV ShoresSwitzerland 21.30
Nickelodeon PTAustria 14.78
MTV PLUnited Kingdom 18.05
MTV ITPoland 7.50
MTVLAFrance 13.15
MTV PLGermany 15.02
MTV NLIndonesia 4.11
Comedy Central BRAustralia 20.86
Channel Does not existHong Kong 12.73
Nickelodeon DEAustralia 20.75
Nickelodeon PTAustralia 20.67
MTV PortugalChile 8.62
MTV AUUnited Kingdom 16.59
Nickelodeon РоссияMexico 4.90
MTV FRSwitzerland 17.72
Nickelodeon SpainHong Kong 11.30
Nickelodeon DEHong Kong 11.14
Comedy Central BRUnited Kingdom 14.80
MTV AsiaMalaysia 4.49
#N/ARussia 3.50
MTV NLThailand 3.99
MTV FRPoland 5.92
Comedy Central BRFrance 10.30
Channel Does not existPoland 5.79
MTV PortugalThailand 3.80
Nickelodeon РоссияUnited Kingdom 13.40
J-OneFrance 9.57
Channel Does not existMalaysia 3.79
Nickelodeon ITHong Kong 8.98
Nickelodeon NLThailand 3.40
Channel Does not existSwitzerland 13.47
Nickelodeon NLMexico 3.65
MTV PLSweden 9.59
MTV NLFrance 8.62
Nickelodeon PTHong Kong 8.49
Nickelodeon NLSweden 9.29
Big Brother UKRussia 2.75
Nickelodeon NLMalaysia 3.31
MTVLARussia 2.56
MTV PortugalMalaysia 3.22
MTV FRUnited Kingdom 10.26
MTV ShoresAustria 7.85
Channel Does not existAustria 7.84
BET OfficielFrance 7.22
Comedy Central BRSwitzerland 10.88
MTV ITSweden 7.46
MTVLASweden 7.43
Channel Does not existIndonesia 2.08
Nickelodeon NLUnited Kingdom 8.82
Nickelodeon РоссияSweden 7.11
MTVLASwitzerland 9.76
MTV ITAustria 6.80
Comedy Central BRSweden 6.92
MTV FRGermany 6.97
MTV FRAustralia 9.21
MTV FRChile 3.88
Channel Does not existMexico 2.37
Nickelodeon NLChile 3.82
Channel Does not existThailand 2.10
MTV FRSweden 6.01
MTV PLMexico 2.27
MTV ITMexico 2.26
MTV ShoresHong Kong 4.83
Game OneRussia 1.60
MTV PLAustria 5.06
Comedy Central DEThailand 1.75
MTVLAThailand 1.74
Comedy Central BRGermany 5.19
Channel Does not existGermany 5.19
Big Brother UKHong Kong 4.33
Nickelodeon NLPoland 2.42
Big Brother UKBrazil 1.77
MTVLAMalaysia 1.74
Big Brother UKAustralia 6.72
MTVLAUnited Kingdom 5.57
MTV BrasilIndonesia 1.29
MTVLAGermany 4.64
Comedy Central DEPoland 2.25
Big Brother UKFrance 3.92
MTV NLGermany 4.51
MTV Base AfricaUnited Kingdom 5.11
MTV PLHong Kong 3.68
Channel Does not existSwitzerland 5.74
Comedy Central BRThailand 1.39
Channel Does not existFrance 3.58
Nickelodeon РоссияAustralia 5.77
MTVLAAustralia 5.69
MTV FRAustria 3.78
Nickelodeon NLAustria 3.73
Big Brother UKPoland 1.93
Nickelodeon NLAustralia 5.41
Game OneIndonesia 1.03
Comedy Central BRRussia 1.07
MTV PLSwitzerland 5.01
MTV PLChile 2.20
Comedy Central DEFrance 3.17
Nickelodeon NLSwitzerland 4.91
Nickelodeon РоссияAustria 3.34
Channel Does not existHong Kong 3.01
MTV AUAustralia 4.89
Comedy Central DERussia 1.00
MTV NLSweden 3.30
Comedy Central BRIndonesia 0.94
VIVA.tvRussia 0.94
Comedy Central DEIndonesia 0.90
MTV PLAustralia 4.46
MTV GermanyIndonesia 0.87
VIVA.tvGermany 3.08
Channel Does not existPoland 1.52
Paramount ComedyPoland 1.51
MTV ITHong Kong 2.58
MTV SpainMexico 1.09
MTV AsiaRussia 0.84
Comedy Central NLThailand 0.97
Channel Does not existAustria 2.70
MTV ITChile 1.70
Channel Does not existChile 1.64
MTV AsiaHong Kong 2.37
Comedy Central BRPoland 1.37
MTV NLAustria 2.56
MTV PortugalBrazil 0.98
Comedy Central ItaliaSwitzerland 3.60
Big Brother UKSweden 2.54
Game OneThailand 0.88
MTV NLUnited Kingdom 3.09
Comedy Central NLIndonesia 0.72
MTV SpainChile 1.54
MTV ITAustralia 3.61
MTV FRHong Kong 2.12
Big Brother UKGermany 2.38
Comedy Central BRMalaysia 0.84
MTVLAPoland 1.15
MTV PortugalPoland 1.13
Game OneSwitzerland 3.03
MTV PortugalFrance 1.91
MTV Base AfricaMalaysia 0.78
Nickelodeon РоссияHong Kong 1.84
MTV NLRussia 0.61
MTV AUIndonesia 0.57
J-OneIndonesia 0.56
MTV NLMalaysia 0.73
Comedy Central DESweden 1.94
Comedy Central BRAustria 1.88
Nickelodeon РоссияSwitzerland 2.66
MTV NLAustralia 2.62
MTVLAAustria 1.75
Game OneMexico 0.68
MTV BrasilFrance 1.60
Game OneSweden 1.64
Game OnePoland 0.83
Comedy Central DEAustralia 2.24
Big Brother UKMexico 0.57
MTV GermanyPoland 0.76
MTV AUSweden 1.47
Comedy Central DEUnited Kingdom 1.81
Comedy Central BRMexico 0.55
MTV NLPoland 0.75
Comedy Central NLGermany 1.50
MTV ZAIndonesia 0.41
MTV NLSwitzerland 1.98
Channel 5Indonesia 0.39
Comedy Central ItaliaFrance 1.20
MTV BrasilSwitzerland 1.85
MTV Base AfricaRussia 0.38
Spike NLIndonesia 0.36
Game OneMalaysia 0.48
Channel Does not existRussia 0.38
Comedy Central NLSweden 1.27
Game OneUnited Kingdom 1.56
Channel 5Australia 1.83
Comedy Central BRChile 0.76
Comedy Central BRHong Kong 1.09
Game OneChile 0.74
Spike NLFrance 1.08
Paramount Network InternationalIndonesia 0.32
MTV PortugalRussia 0.33
MTV BrasilMalaysia 0.41
Paramount ComedyThailand 0.38
Big Brother UKChile 0.67
Comedy Central NLFrance 0.98
MTV GermanyRussia 0.32
Comedy Central NLUnited Kingdom 1.33
MTV PortugalHong Kong 0.95
MTV Base AfricaFrance 0.95
Game OneGermany 1.03
MTV PortugalSweden 0.99
MTV Base AfricaIndonesia 0.27
Comedy Central ItaliaUnited Kingdom 1.15
Comedy Central NLAustria 0.90
Game OneAustralia 1.31
MTVLAHong Kong 0.80
MTV GermanyFrance 0.79
Nickelodeon NLHong Kong 0.79
MTV GermanyMalaysia 0.33
MTV NLHong Kong 0.75
Comedy Central NLMalaysia 0.32
MTV AUMalaysia 0.32
MTV BrasilThailand 0.29
MTV AsiaUnited Kingdom 1.03
Big Brother UKAustria 0.80
Paramount Network InternationalRussia 0.24
Comedy Central ItaliaGermany 0.84
MTV Base AfricaSweden 0.80
Comedy Central DEBrazil 0.30
Comedy Central NLPoland 0.40
MTV PortugalGermany 0.78
MTV AsiaPoland 0.38
MTV BrasilRussia 0.22
MTV Base AfricaAustralia 1.07
MTV Base AfricaGermany 0.74
Big Brother UKSwitzerland 0.99
Comedy Central DEHong Kong 0.62
MTV AsiaAustralia 0.98
MTV AUBrazil 0.26
Comedy Central NLSwitzerland 0.94
MTV AUThailand 0.23
MTV BrasilUnited Kingdom 0.80
VIVA.tvAustria 0.62
Comedy Central NLRussia 0.19
MTV PortugalUnited Kingdom 0.78
MTV BrasilAustralia 0.90
MTV PortugalSwitzerland 0.86
Game OneAustria 0.58
MTV AUFrance 0.54
Comedy Central DEMalaysia 0.22
VIVA.tvPoland 0.31
MTV AUPoland 0.31
Channel 5Thailand 0.21
Comedy Central ItaliaThailand 0.21
Game OneBrazil 0.22
Paramount ComedyGermany 0.60
MTV AUGermany 0.60
MTV BrasilMexico 0.21
Game OneHong Kong 0.47
Channel 5Malaysia 0.20
MTV NLBrazil 0.19
Comedy Central NLHong Kong 0.45
MTV BrasilChile 0.30
Paramount ComedyIndonesia 0.14
Comedy Central ItaliaPoland 0.25
Channel 5Russia 0.14
J-OneMalaysia 0.18
Comedy Central ItaliaRussia 0.13
Paramount Network InternationalChile 0.27
MTV GermanyUnited Kingdom 0.53
Comedy Central NLAustralia 0.60
MTV PortugalAustria 0.40
Paramount ComedyFrance 0.37
Paramount Network InternationalMexico 0.16
VIVA.tvSwitzerland 0.57
MTV GermanyThailand 0.14
MTV AsiaFrance 0.35
Spike NLGermany 0.39
Channel Does not existMexico 0.14
MTV AsiaSweden 0.37
MTV Base AfricaAustria 0.35
MTV BrasilSweden 0.35
MTV Base AfricaThailand 0.12
Neighbours TVUnited Kingdom 0.44
MTV PortugalAustralia 0.49
MTV AsiaBrazil 0.13
Comedy Central ItaliaAustralia 0.46
MTV BrasilGermany 0.33
J-OneSwitzerland 0.44
Comedy Central ItaliaAustria 0.29
MTV SpainBrazil 0.11
MTV ZAMalaysia 0.11
Spike NLRussia 0.09
Channel 5Sweden 0.30
MTV GermanyAustralia 0.41
Paramount ComedyAustria 0.27
MTV AUAustria 0.27
Channel 5France 0.25
MTV AsiaGermany 0.29
Comedy Central ItaliaIndonesia 0.08
MTV NLMexico 0.11
MTV AURussia 0.08
Paramount ComedyUnited Kingdom 0.34
Comedy Central DEChile 0.16
MTV Base AfricaHong Kong 0.23
Comedy Central DEMexico 0.10
BET OfficielUnited Kingdom 0.32
Spike NLAustria 0.24
Paramount Network InternationalBrazil 0.09
Paramount Network InternationalFrance 0.22
Comedy Central ItaliaSweden 0.24
MTV AUSwitzerland 0.34

<colgroup><col><col><col></colgroup><tbody>
</tbody>
 
Upvote 0
you didn't show what you want to achieve but maybe:

CountryChannel NameSum of DELIVERED $ NET
AustraliaBig 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​
AustriaBellator 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​
BrazilBig 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​
ChileBellator 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​
FranceBET 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​
GermanyBellator 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 KongBellator 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​
IndonesiaBig 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​
MalaysiaBellator 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​
MexicoBellator 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​
PolandBellator 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​
RussiaBig 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​
SwedenBellator 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​
SwitzerlandBellator 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​
ThailandBellator 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 KingdomBET 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
 
Upvote 0
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
 
Upvote 0
to be sure: greater than 100 or less than 100? (post#1)

for greater than 100

CountryChannel NameDelivered & Net
AustraliaNickelodeon PT
761.67​
AustraliaNickelodeon DE
881.87​
AustraliaMTV Shores
686.67​
AustraliaComedy Central DE
299.85​
AustraliaNickelodeon France
763.76​
AustraliaMTV Germany
444.39​
AustraliaNickelodeon ??????
168.96​
AustraliaBellator MMA
1003.32​
AustraliaNick Jr. ??????
1095.16​
AustraliaMTV PL
185.02​
AustraliaNickelodeon IT
882.54​
AustraliaBig Brother UK
151.36​
AustraliaNickelodeon Spain
633.94​
AustraliaNickelodeon NL
107.36​
AustraliaComedy Central Spain
958.93​
AustraliaChannel Does not exist
841.21​
AustraliaMTV FR
301.72​
AustraliaMTV International
970.52​
AustraliaMTV IT
408.37​
AustriaBig Brother UK
151.36​
AustriaComedy Central Spain
958.93​
AustriaMTV Germany
444.39​
AustriaBellator MMA
1003.32​
AustriaNickelodeon IT
882.54​
AustriaChannel Does not exist
841.21​
AustriaNickelodeon France
763.76​
AustriaMTV IT
408.37​
AustriaNick Jr.
583.04​
AustriaNickelodeon Spain
633.94​
AustriaMTV PL
185.02​
AustriaMTV International
970.52​
AustriaNickelodeon NL
107.36​
AustriaNick Jr. ??????
1095.16​
AustriaNickelodeon ??????
168.96​
AustriaNickelodeon UK
504.76​
AustriaMTV Shores
686.67​
AustriaMTV FR
301.72​
AustriaNickelodeon PT
761.67​
AustriaComedy Central UK
926.12​
BrazilComedy Central DE
299.85​
BrazilNickelodeon ??????
168.96​
BrazilMTV PL
185.02​
BrazilChannel Does not exist
841.21​
BrazilMTV IT
408.37​
BrazilNickelodeon NL
107.36​
BrazilBellator MMA
1003.32​
BrazilComedy Central Spain
958.93​
BrazilMTV FR
301.72​
BrazilComedy Central UK
926.12​
BrazilMTV Shores
686.67​
BrazilMTV International
970.52​
BrazilBig Brother UK
151.36​
ChileComedy Central Spain
958.93​
ChileComedy Central DE
299.85​
ChileComedy Central UK
926.12​
ChileNickelodeon DE
881.87​
ChileMTV IT
408.37​
ChileNickelodeon PT
761.67​
ChileMTV International
970.52​
ChileBig Brother UK
151.36​
ChileNickelodeon NL
107.36​
ChileMTV FR
301.72​
ChileNickelodeon France
763.76​
ChileChannel Does not exist
841.21​
ChileMTV PL
185.02​
ChileNickelodeon ??????
168.96​
ChileBellator MMA
1003.32​
ChileNickelodeon IT
882.54​
FranceNickelodeon PT
761.67​
FranceMTV Germany
444.39​
FranceMTV FR
301.72​
FranceNickelodeon DE
881.87​
FranceComedy Central Spain
958.93​
FranceBellator MMA
1003.32​
FranceMTV Shores
686.67​
FranceMTV International
970.52​
FranceNickelodeon Spain
633.94​
FranceNickelodeon ??????
168.96​
FranceNickelodeon NL
107.36​
FranceChannel Does not exist
841.21​
FranceMTV IT
408.37​
FranceNickelodeon IT
882.54​
FranceMTV PL
185.02​
FranceNick Jr. ??????
1095.16​
FranceBig Brother UK
151.36​
FranceComedy Central DE
299.85​
GermanyComedy Central Spain
958.93​
GermanyBellator MMA
1003.32​
GermanyMTV PL
185.02​
GermanyChannel Does not exist
841.21​
GermanyMTV Shores
686.67​
GermanyBig Brother UK
151.36​
GermanyMTV IT
408.37​
GermanyMTV FR
301.72​
GermanyMTV International
970.52​
Hong KongNickelodeon IT
882.54​
Hong KongMTV Shores
686.67​
Hong KongComedy Central DE
299.85​
Hong KongMTV International
970.52​
Hong KongNickelodeon UK
504.76​
Hong KongChannel Does not exist
841.21​
Hong KongMTV FR
301.72​
Hong KongComedy Central Spain
958.93​
Hong KongNickelodeon NL
107.36​
Hong KongNick Jr. ??????
1095.16​
Hong KongNickelodeon ??????
168.96​
Hong KongNick Jr.
583.04​
Hong KongNickelodeon France
763.76​
Hong KongMTV PL
185.02​
Hong KongMTV IT
408.37​
Hong KongBellator MMA
1003.32​
Hong KongBig Brother UK
151.36​
Hong KongNickelodeon Spain
633.94​
Hong KongNickelodeon PT
761.67​
Hong KongNickelodeon DE
881.87​
IndonesiaMTV IT
408.37​
IndonesiaComedy Central Spain
958.93​
IndonesiaNickelodeon ??????
168.96​
IndonesiaChannel Does not exist
841.21​
IndonesiaMTV Germany
444.39​
IndonesiaComedy Central DE
299.85​
IndonesiaMTV Shores
686.67​
IndonesiaNickelodeon NL
107.36​
IndonesiaBig Brother UK
151.36​
MalaysiaNickelodeon DE
881.87​
MalaysiaNickelodeon PT
761.67​
MalaysiaNick Jr. ??????
1095.16​
MalaysiaMTV Germany
444.39​
MalaysiaNickelodeon IT
882.54​
MalaysiaNickelodeon ??????
168.96​
MalaysiaBellator MMA
1003.32​
MalaysiaMTV FR
301.72​
MalaysiaNickelodeon NL
107.36​
MalaysiaMTV Shores
686.67​
MalaysiaMTV International
970.52​
MalaysiaComedy Central Spain
958.93​
MalaysiaNickelodeon France
763.76​
MalaysiaMTV IT
408.37​
MalaysiaMTV PL
185.02​
MalaysiaBig Brother UK
151.36​
MalaysiaNickelodeon Spain
633.94​
MalaysiaChannel Does not exist
841.21​
MalaysiaComedy Central DE
299.85​
MexicoComedy Central Spain
958.93​
MexicoNickelodeon PT
761.67​
MexicoMTV International
970.52​
MexicoComedy Central DE
299.85​
MexicoMTV IT
408.37​
MexicoNick Jr. ??????
1095.16​
MexicoNickelodeon NL
107.36​
MexicoChannel Does not exist
841.21​
MexicoNickelodeon France
763.76​
MexicoNickelodeon DE
881.87​
MexicoNickelodeon IT
882.54​
MexicoMTV PL
185.02​
MexicoComedy Central UK
926.12​
MexicoMTV FR
301.72​
MexicoNickelodeon ??????
168.96​
MexicoBellator MMA
1003.32​
MexicoBig Brother UK
151.36​
PolandMTV FR
301.72​
PolandNickelodeon Spain
633.94​
PolandBig Brother UK
151.36​
PolandMTV Germany
444.39​
PolandNickelodeon ??????
168.96​
PolandNickelodeon NL
107.36​
PolandComedy Central DE
299.85​
PolandNickelodeon DE
881.87​
PolandComedy Central Spain
958.93​
PolandMTV Shores
686.67​
PolandNick Jr. ??????
1095.16​
PolandNickelodeon France
763.76​
PolandChannel Does not exist
841.21​
PolandMTV International
970.52​
PolandComedy Central UK
926.12​
PolandBellator MMA
1003.32​
PolandMTV IT
408.37​
PolandNickelodeon IT
882.54​
PolandNickelodeon PT
761.67​
RussiaNickelodeon IT
882.54​
RussiaMTV IT
408.37​
RussiaNickelodeon France
763.76​
RussiaMTV FR
301.72​
RussiaMTV International
970.52​
RussiaNickelodeon DE
881.87​
RussiaComedy Central DE
299.85​
RussiaChannel Does not exist
841.21​
RussiaNickelodeon PT
761.67​
RussiaMTV Germany
444.39​
RussiaMTV PL
185.02​
RussiaNickelodeon NL
107.36​
RussiaComedy Central Spain
958.93​
RussiaBig Brother UK
151.36​
RussiaMTV Shores
686.67​
SwedenNickelodeon Spain
633.94​
SwedenNickelodeon France
763.76​
SwedenMTV International
970.52​
SwedenMTV IT
408.37​
SwedenMTV PL
185.02​
SwedenNickelodeon DE
881.87​
SwedenComedy Central Spain
958.93​
SwedenNickelodeon NL
107.36​
SwedenNick Jr. ??????
1095.16​
SwedenMTV FR
301.72​
SwedenNickelodeon PT
761.67​
SwedenMTV Shores
686.67​
SwedenNickelodeon IT
882.54​
SwedenNickelodeon ??????
168.96​
SwedenChannel Does not exist
841.21​
SwedenComedy Central DE
299.85​
SwedenBig Brother UK
151.36​
SwedenBellator MMA
1003.32​
SwitzerlandComedy Central UK
926.12​
SwitzerlandNickelodeon NL
107.36​
SwitzerlandMTV IT
408.37​
SwitzerlandBellator MMA
1003.32​
SwitzerlandNick Jr. ??????
1095.16​
SwitzerlandMTV PL
185.02​
SwitzerlandNickelodeon DE
881.87​
SwitzerlandNickelodeon PT
761.67​
SwitzerlandBig Brother UK
151.36​
SwitzerlandNickelodeon ??????
168.96​
SwitzerlandNickelodeon France
763.76​
SwitzerlandMTV Germany
444.39​
SwitzerlandComedy Central Spain
958.93​
SwitzerlandNickelodeon UK
504.76​
SwitzerlandNickelodeon Spain
633.94​
SwitzerlandMTV International
970.52​
SwitzerlandComedy Central DE
299.85​
SwitzerlandNickelodeon IT
882.54​
SwitzerlandMTV FR
301.72​
SwitzerlandChannel Does not exist
841.21​
SwitzerlandMTV Shores
686.67​
SwitzerlandNick Jr.
583.04​
ThailandBellator MMA
1003.32​
ThailandNickelodeon IT
882.54​
ThailandComedy Central DE
299.85​
ThailandNickelodeon ??????
168.96​
ThailandNick Jr. ??????
1095.16​
ThailandNickelodeon PT
761.67​
ThailandNickelodeon NL
107.36​
ThailandMTV Germany
444.39​
ThailandMTV Shores
686.67​
ThailandMTV FR
301.72​
ThailandComedy Central Spain
958.93​
ThailandNickelodeon France
763.76​
ThailandNickelodeon Spain
633.94​
ThailandMTV IT
408.37​
ThailandBig Brother UK
151.36​
ThailandMTV PL
185.02​
ThailandMTV International
970.52​
ThailandChannel Does not exist
841.21​
ThailandNickelodeon DE
881.87​
United KingdomNickelodeon NL
107.36​
United KingdomNickelodeon France
763.76​
United KingdomChannel Does not exist
841.21​
United KingdomNickelodeon PT
761.67​
United KingdomMTV FR
301.72​
United KingdomMTV IT
408.37​
United KingdomComedy Central Spain
958.93​
United KingdomComedy Central DE
299.85​
United KingdomBig Brother UK
151.36​
United KingdomNick Jr. ??????
1095.16​
United KingdomNickelodeon Spain
633.94​
United KingdomNickelodeon DE
881.87​
United KingdomMTV Germany
444.39​
United KingdomNickelodeon IT
882.54​
United KingdomMTV Shores
686.67​
United KingdomNickelodeon ??????
168.96​
United KingdomBellator MMA
1003.32​
United KingdomMTV PL
185.02​

for less than 100

CountryChannel NameDelivered & Net
AustraliaMTV Brasil
8.55​
AustraliaComedy Central NL
10.57​
AustraliaGame One
84.03​
AustraliaComedy Central BR
78.84​
AustraliaChannel 5
23.69​
AustraliaMTV AU
26.47​
AustraliaMTV Portugal
61.96​
AustraliaComedy Central Italia
8.45​
AustraliaMTV Asia
24.02​
AustraliaMTVLA
76​
AustraliaMTV Base Africa
10.8​
AustraliaMTV NL
37.92​
AustriaMTV AU
26.47​
AustriaVIVA.tv
5.52​
AustriaGame One
84.03​
AustriaMTV Base Africa
10.8​
AustriaComedy Central NL
10.57​
AustriaMTVLA
76​
AustriaParamount Comedy
3.61​
AustriaComedy Central Italia
8.45​
AustriaMTV NL
37.92​
AustriaSpike NL
2.16​
AustriaMTV Portugal
61.96​
AustriaComedy Central BR
78.84​
BrazilGame One
84.03​
BrazilMTV Spain
2.74​
BrazilMTV Portugal
61.96​
BrazilMTVLA
76​
BrazilMTV NL
37.92​
BrazilMTV AU
26.47​
BrazilParamount Network International
1.3​
BrazilMTV Asia
24.02​
ChileParamount Network International
1.3​
ChileMTV Portugal
61.96​
ChileMTV Spain
2.74​
ChileComedy Central BR
78.84​
ChileGame One
84.03​
ChileMTV Brasil
8.55​
FranceJ-One
10.75​
FranceMTV NL
37.92​
FranceMTV Base Africa
10.8​
FranceBET Officiel
7.54​
FranceMTV Asia
24.02​
FranceMTV Brasil
8.55​
FranceChannel 5
23.69​
FranceMTVLA
76​
FranceSpike NL
2.16​
FranceComedy Central BR
78.84​
FranceComedy Central Italia
8.45​
FranceGame One
84.03​
FranceComedy Central NL
10.57​
FranceMTV AU
26.47​
FranceMTV Portugal
61.96​
FranceParamount Network International
1.3​
FranceParamount Comedy
3.61​
GermanyMTV Brasil
8.55​
GermanyMTV Portugal
61.96​
GermanyComedy Central BR
78.84​
GermanySpike NL
2.16​
GermanyMTV NL
37.92​
GermanyVIVA.tv
5.52​
GermanyMTV AU
26.47​
GermanyParamount Comedy
3.61​
GermanyMTVLA
76​
GermanyMTV Base Africa
10.8​
GermanyComedy Central Italia
8.45​
GermanyMTV Asia
24.02​
GermanyGame One
84.03​
GermanyComedy Central NL
10.57​
Hong KongMTV NL
37.92​
Hong KongComedy Central BR
78.84​
Hong KongMTVLA
76​
Hong KongComedy Central NL
10.57​
Hong KongMTV Portugal
61.96​
Hong KongMTV Base Africa
10.8​
Hong KongGame One
84.03​
Hong KongMTV Asia
24.02​
IndonesiaMTV ZA
0.52​
IndonesiaSpike NL
2.16​
IndonesiaMTV Portugal
61.96​
IndonesiaComedy Central BR
78.84​
IndonesiaParamount Network International
1.3​
IndonesiaComedy Central Italia
8.45​
IndonesiaParamount Comedy
3.61​
IndonesiaMTV Base Africa
10.8​
IndonesiaMTV Brasil
8.55​
IndonesiaMTV AU
26.47​
IndonesiaJ-One
10.75​
IndonesiaComedy Central NL
10.57​
IndonesiaMTVLA
76​
IndonesiaGame One
84.03​
IndonesiaChannel 5
23.69​
IndonesiaMTV Asia
24.02​
IndonesiaMTV NL
37.92​
MalaysiaMTV NL
37.92​
MalaysiaMTV Asia
24.02​
MalaysiaChannel 5
23.69​
MalaysiaMTVLA
76​
MalaysiaMTV Brasil
8.55​
MalaysiaComedy Central NL
10.57​
MalaysiaJ-One
10.75​
MalaysiaGame One
84.03​
MalaysiaMTV ZA
0.52​
MalaysiaMTV Base Africa
10.8​
MalaysiaMTV Portugal
61.96​
MalaysiaMTV AU
26.47​
MalaysiaComedy Central BR
78.84​
MexicoParamount Network International
1.3​
MexicoMTV Spain
2.74​
MexicoComedy Central BR
78.84​
MexicoMTV Portugal
61.96​
MexicoMTV Brasil
8.55​
MexicoMTV NL
37.92​
MexicoGame One
84.03​
PolandMTV Asia
24.02​
PolandVIVA.tv
5.52​
PolandMTVLA
76​
PolandParamount Comedy
3.61​
PolandMTV NL
37.92​
PolandMTV AU
26.47​
PolandComedy Central BR
78.84​
PolandMTV Portugal
61.96​
PolandComedy Central Italia
8.45​
PolandGame One
84.03​
PolandComedy Central NL
10.57​
RussiaParamount Network International
1.3​
RussiaComedy Central BR
78.84​
RussiaVIVA.tv
5.52​
RussiaComedy Central Italia
8.45​
RussiaMTV Asia
24.02​
RussiaMTVLA
76​
RussiaGame One
84.03​
RussiaSpike NL
2.16​
RussiaComedy Central NL
10.57​
RussiaMTV Portugal
61.96​
Russia
3.5​
RussiaMTV Base Africa
10.8​
RussiaMTV Brasil
8.55​
RussiaMTV AU
26.47​
RussiaMTV NL
37.92​
RussiaChannel 5
23.69​
SwedenChannel 5
23.69​
SwedenMTV Asia
24.02​
SwedenComedy Central NL
10.57​
SwedenMTVLA
76​
SwedenGame One
84.03​
SwedenMTV NL
37.92​
SwedenComedy Central BR
78.84​
SwedenMTV Portugal
61.96​
SwedenMTV Base Africa
10.8​
SwedenMTV AU
26.47​
SwedenMTV Brasil
8.55​
SwedenComedy Central Italia
8.45​
SwitzerlandComedy Central BR
78.84​
SwitzerlandComedy Central NL
10.57​
SwitzerlandMTV NL
37.92​
SwitzerlandJ-One
10.75​
SwitzerlandGame One
84.03​
SwitzerlandMTV AU
26.47​
SwitzerlandMTV Portugal
61.96​
SwitzerlandComedy Central Italia
8.45​
SwitzerlandMTV Brasil
8.55​
SwitzerlandMTVLA
76​
SwitzerlandVIVA.tv
5.52​
ThailandMTVLA
76​
ThailandMTV Asia
24.02​
ThailandGame One
84.03​
ThailandChannel 5
23.69​
ThailandParamount Comedy
3.61​
ThailandMTV AU
26.47​
ThailandMTV Base Africa
10.8​
ThailandMTV NL
37.92​
ThailandMTV Brasil
8.55​
ThailandMTV Portugal
61.96​
ThailandComedy Central BR
78.84​
ThailandComedy Central NL
10.57​
ThailandComedy Central Italia
8.45​
United KingdomNeighbours TV
0.44​
United KingdomMTV AU
26.47​
United KingdomMTV Asia
24.02​
United KingdomChannel 5
23.69​
United KingdomComedy Central BR
78.84​
United KingdomMTV Base Africa
10.8​
United KingdomComedy Central NL
10.57​
United KingdomComedy Central Italia
8.45​
United KingdomGame One
84.03​
United KingdomBET Officiel
7.54​
United KingdomMTV NL
37.92​
United KingdomMTVLA
76​
United KingdomMTV Portugal
61.96​
United KingdomParamount Comedy
3.61​
United KingdomMTV Brasil
8.55​
 
Last edited:
Upvote 0
or with PivotTable and filter less than 100

Channel NameCountrySum of DELIVERED $ NET
BET OfficielFrance
7.22​
United Kingdom
0.32​
Channel 5Australia
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 BRAustralia
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 ItaliaAustralia
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 NLAustralia
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 OneAustralia
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-OneFrance
9.57​
Indonesia
0.56​
Malaysia
0.18​
Switzerland
0.44​
MTV AsiaAustralia
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 AUAustralia
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 AfricaAustralia
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 BrasilAustralia
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 NLAustralia
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 PortugalAustralia
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 SpainBrazil
0.11​
Chile
1.54​
Mexico
1.09​
MTV ZAIndonesia
0.41​
Malaysia
0.11​
MTVLAAustralia
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 TVUnited Kingdom
0.44​
Paramount ComedyAustria
0.27​
France
0.37​
Germany
0.6​
Indonesia
0.14​
Poland
1.51​
Thailand
0.38​
United Kingdom
0.34​
Paramount Network InternationalBrazil
0.09​
Chile
0.27​
France
0.22​
Indonesia
0.32​
Mexico
0.16​
Russia
0.24​
Spike NLAustria
0.24​
France
1.08​
Germany
0.39​
Indonesia
0.36​
Russia
0.09​
VIVA.tvAustria
0.62​
Germany
3.08​
Poland
0.31​
Russia
0.94​
Switzerland
0.57​
#N/ARussia
3.5​
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,207
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top