8 Replies Latest reply: Oct 5, 2018 3:40 AM by surya j RSS

    How to use two identifiers in one set analysis

    surya j

      Hi


      I am trying to use two identifiers in one set analysis.


      In the below case i dint want my formula to consider Type Field that i mentioned like 1<TYPE= & remaining fields has to be considered

      ex country_name,ww_segment etc.


      How to achieve this?



      (SUM({1<TYPE=,fiscal_quarter=,week_start ={">=$(=date(QuarterStart(Max(week_start)))) <=$(=date(AddYears(Max(week_start))))"}

      ,country_name,ww_segment=,bpc_segment_description=,geography

      >}accessories_revenue_yoy)