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

dbaksa_1 — Tue, 22 Jul 2025 17:59:49 GMT

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

topic Set Analysis - Fixed Timeframe, Allow selection of all other dimensions in Archived Groups

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