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
