0 Replies Latest reply: Apr 16, 2015 8:41 AM by Daniel Baksa RSS

    Set Analysis - Fixed Timeframe, Allow selection of all other dimensions

    Daniel Baksa

      Below is a set analysis statement and I would like to lock the date timeframes but still allow the user to select any other dimensions. If I use a set identifier of 1 I get the total over the entire set but what I want is the total for the timeframe but still allow the user select all other dimensions.

       

      What I need to do is ignore selections to [FISCAL YEAR] and [FISCPER3.FISCAL PERIOD] while allowing selections on any other dimension.

       

      //Sales NOTS
      sum({$<[FISCAL YEAR] = {$(vThisYear)}, [FISCPER3.Fiscal Period] = {"< $(vThisMonth)"},[JBASalesTransactionIndicator] = {'SAL'},[SalesDistType] = {'USBP'}>}[BD Sales NOTS])
      +
      sum({$<[FISCAL YEAR] = {$(vThisYear)}, [FISCPER3.Fiscal Period] = {"< $(vThisMonth)"},[JBASalesTransactionIndicator] = {'SAL'},[SalesDistType] = {'USBP'}>}[BP Sales NOTS])

       

       

      Thanks,

       

      Dan