my Second Pick is not getting calculated after applying filter
I am trying to put all numbers Manually Product wise.
So when i apply filter on [TerritoryLevel4] ='S_UKI' it still shows value for [TerritoryLevel3]='S_EMEA'
Please help
E.g.
If([TerritoryLevel3]='S_EMEA',(Pick(Match([Product Sub Category],'A','B','C',
'D','E','F','G','H','I','J','K','L','M','N')+1,
7087645,3100720,7239302,3495407,11574307,1767474,5451370,4072107,9562232,3658490,4785699,322131,6208621,5825034,0))/1000000,
If([TerritoryLevel4] ='S_UKI',
(Pick(Match([Product Sub Category],'A','B','C',
'D','E','F','G','H','I','J','K','L','M','N')+1,
'1774348','655502','1518050','517787','2101909','-9183','3072889','853903','1993201','1183086','2501750','37068','1279540','1723476','0')/1000000),''))
