6 Replies Latest reply: Feb 17, 2014 11:05 PM by vikas mahajan RSS

    Comparative Analysis

    ben lim

      Hi all,

       

      I am using comparative analysis to do an ad hoc template for user to nagivate around. (Aka alternate state)

      On the Script I have this code

       

      _Dimension_PMX:

      LOAD * INLINE [
      _Dimension_PMX
      Box
      TEU

       

      this means that if user check on TEU, the table will appear box on expression using conditional format

        =SubStringCount(Concat(_Dimension_PMX, '|'), 'TEU')

       

      and my expression to that conditional expression is

      sum({[Group 1]}TEU)

       

      However, for this report i woud like my expressions to have set analysis where Activity_Code = 'LOAD'. This is to cater a certain ad hoc template for this

      meaning if is without alternative anaysis, it will be sum({<Activity_Code = {'LOAD'}>}TEU)

       

      I would not want user to select Load activity code everytime as it defeat the purpose

       

      thanks!