4 Replies Latest reply: Dec 21, 2011 11:40 PM by Kamal Naithani RSS

    Group analysis and set analysis without write all fields

    Panetta Luca Jonathan

      Hi,

       

      I want to use altenate state to make analysis on 2 periods, for this I use 2 alternate state "Period1, Period2" and I have set this on Year and Month fields.

       

      Now when I create my chart and I write the expression do

       

      =sum ({[Period1] <AgentName=$::[AgentName], Region=$::[Region], LocalState=$::[LocalState], Product=$::[Product] >} Quantity)

       

      =sum ({[Period2] <AgentName=$::[AgentName], Region=$::[Region], LocalState=$::[LocalState], Product=$::[Product] >} Quantity)

       

      Exist a way to don't write the part between < ... >?

      I have many fields and is boring to write always all fields only to specify $::

       

      Regards

       

      Luca Jonathan Panetta

      PLJ Software