5 Replies Latest reply: Feb 6, 2014 9:50 AM by James Summerson RSS

    Set Analysis

      Hi all

       

      I have a script with one fact table and two dimension tables.

       

      One of the dimension tables is a calendar with each calendar date in it, which includes various groupings like Year, Week, YTD, QTD, LastWeek, LastMonth etc.

       

      On most of the sheets in my report I want the figures to be sliced and diced by the various date selections, however on one sheet I want the data to be sliced by the fields in the other dimension table only.

       

      I am using set analysis, but rather than ask the formula to ignore each calendar field seperately in something like the following

       

      =Sum({$<YTD=, ThisWeek=, ThisMonth=>}FactValue)

       

      Is there a way to use set analysis to ignore all field selections except the ones that I specify?  I know you can use 1 as the identifier, but how then do I ask the expression to honour the selection in a field like 'Depot'

       

      =Sum({1<Depot={[Selection]}, ReportGroup={[Selection]}>}FactValue)

       

      Thanks

       

      James