2 Replies Latest reply on Apr 19, 2012 2:06 AM by Fionnuala Gibney

    Using parameters to filter an aggregation

    Fionnuala Gibney

      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