1 Reply Latest reply: Jan 4, 2018 12:41 AM by P M RSS

    Display Latest Quarter in KPI

    Monu Saraswati

      Hi ,


      I want the latest Quarter to be display in the KPI object.

      Example - "Q1-2018" . Quarter Column is coming from the table. Please let me know what function can be used to get the latest quarter value in the KPI object.



        • Re: Display Latest Quarter in KPI
          P M

          Try this



          ,[Posting Date]={">=$(=QuarterStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date])))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}

          >}[Sales Amount])




          ,[Posting Date]={">=$(=QuarterStart(max([Posting Date])))<=$(=max([Posting Date]))"}

          >}[Sales Amount])