Hi all,
I have a simple (filled) map of total sales, I have added a parameter which allows the user to select a sales level above which to view the data at. i.e. a threshold of USD 10,000. And then a calculated field True/False where Sales > Threshold -- which I had a filter on for the map.
However, this applies to the individual sales, not the sum of the sales into the zipcode, so I changed the calculated field to show 'SUM([Sales]) > Threshold', but then this field can't be dropped into the filters selection.
I'm sure there's an obvious way to do this, but I can't seem to find it in the help or the forums -- if someone could point me in the right direction I'd appreciate it.
Thanks!
Fionnuala
Hi Finnuala,
This can be done by changing the calculation to look like the following:
if sum([Sales])>[Threshold] then 1 else 0 end
Then, place this on the level of detail shelf. Right click on it and make sure it is set to Continuous. Right click on it again and select Filter, then filter to 1. Hope this helps!
-Tracy
