3 Replies Latest reply: Feb 5, 2016 2:55 PM by Michal Samborski RSS

    set analysis and filters

    Michal Samborski

      sum({$<Year={2000}”}>} Sales)

       

      Returns the sales for current selection, but with new selection year=2000.  if someone applies a filter year=2001, the above set analysis still returns sum of sales for year 2000.  How do i modify this so that if a user applies no year filter it return sum of sales for year 2000, but if a user applies a filter year other then 2000, then the function returns 0?