6 Replies Latest reply: Feb 2, 2016 8:09 AM by Steve Nase RSS

    Set analysis only when field has no selection

    Steve Nase

      I've been trying hard to figure this out and it seems simple to me, I'm convinced there's something I'm missing. 


      I want to do set analysis on a chart; for example Sum({$ <Year={'2016'}>}TRI) unless there's a selection in the "year" field.  So basically I want the chart to default to the sum of TRI where year is 2016 UNLESS the user has a selection in year.  I've thought of a few workarounds that I don't like, but I'm convinced there must be a way to do exactly what I'm after... Any help is appreciated.