Display Latest Quarter in KPI

[sarasmonu]

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.

Thanks

[prma7799]

Try this

SUM({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear))}

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

>}[Sales Amount])

or

(SUM({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear))}

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

>}[Sales Amount])