22 Replies Latest reply: Jan 19, 2017 10:41 AM by Wallo Atkinson RSS

    Set Analysis Expressions - Inputs from Filter Applied

    Prasanna Chandran

      I have the below set analysis expression which calculates the Sum of Sales for the Reporting Date 31-Dec-2013.

      sum({$<[Reporting Date] = {'31/12/2013'}>} [Sales])

       

      In this I have hardcoded the value 31-Dec-2013. Instead, I need to define this expression, where the Date comes as input from a Filter selection that the user makes.

       

      If user selects 31-Jan-2014, it should be computed for this date. Is there a way to make the expressions generic and receive inputs based on user selections?