Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have city of US only but 2 cities are indicting in Africa and south America. How to remove city from other country and place in US?
if you have a field in your dataset that specifies the region then you can filter specific values using SET ANALYSIS
example
sum( {< Region={"NORTHAMERICA"} > }payment_amount)
OR
Exclude values, below will exclude country1 and country2 from calculation
sum( {< COUNTRY -={'Country1','Country2'} > }payment_amount)
refer below for more on SET ANALYSIS
I don't have such kind of country or region