6 Replies Latest reply: Mar 27, 2016 10:09 AM by rajesh Gurram RSS

    Set analysis pick max month in perticuler Quarter

    rajesh Gurram

      Hi,

       

       

       

       

      please help me in set analysis i want to pick max month in Quarter 2 .my field name is qtr 1,2,3,4,

       

      eg:sum({<FY={$(=Max(FY))},Qtr={'2'},MonthOrder = {"$(= max({<FY={$(=max(FY))}>} MonthOrder)-8)"}>} Amount)

       

       

      Thank you