2 Replies Latest reply: May 1, 2018 11:07 AM by Krishna Nagulapally RSS

    How can i apply condition in a group by expression.

    siddharth soam

      Hi,

       

      I want only those customers to come with revenue< 1mn corresponding to my previous_fiscal year i.e. 1-max(fiscal year). But when I apply the following condition-

       

       

      Temp:

      Load

      ((Max(Mid("Fiscal Year",3)))-1) as Prevfiscalyear

       

      Resident PNL;

      Let vPrevfiscalyear =Peek('Prevfiscalyear');

       

      tab2:

      Load

      "Fiscal Year",

      Quarters,

      "Customer ",

      leaders,

      if(sum(Revenue)<1,'Tail Accounts(Rev<1Mn)',

      ) as Accounts

      Resident PNL

      where "Fiscal Year"=$(vPrevfiscalyear)

      Group by "Fiscal Year","Customer ="leaders;


      I cannot see any customer corresponding to FY18 selection at frontend