Filter values in a pivot table

[ExGus]

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>

 

[sandy666]

2016 so will need to use get and transform

Power Query == Get&Transform

 

[ExGus]

I need it in a table I can then pivot on to get the channel, country revenue so that wouldn't work. it is doing the correct steps till the country gets added back in.

 

[sandy666]

Could you explain what are you doing with the result table after add M-code?

 

[ExGus]

a Pivot like this.. i have just copied the first few rows and have grouped some up by channel.

Row Labels	Sum of Deal amount
Nick Jr.	11,202
Brazil	1,633
United Kingdom	1,173
France	1,170
Australia	1,163
Thailand	1,103
Chile	1,097
Mexico	796
Indonesia	741
Poland	576
Hong Kong	520
Malaysia	399
Sweden	384
Switzerland	230
Austria	123
Russia	94
Comedy Central UK	7,668
Nickelodeon UK	6,760
Nickelodeon Spain	3,444

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[sandy666]

M-code from the post create group and sum total for channels by country so if you pivot this table it will give you wrong result

Query Table is the EndResult