Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to find the previous quarter of the max year.i have to find the previous quarter of the max year having current quarter.
=SUM({<Date= {'>=$(=QuarterStart(Max(Date),-1))<=$(=QuarterEnd(Max(Date),-1))'}>}Sales)
Say you have fields Year,Quarter and MonthYear i.e. MonthName(Date) and your quarter field values are {Q1,Q2,Q3,Q4} and you have selected Q4
Then you can in your expression write something like this
sum({$<MonthYear={'>=$(=MonthYear(AddMonths(Max(Date)),-3))<=$(=MonthYear(Max(Date)))'}>})Sales)
Cheers,
Byron
hi Byron,
The scenario is that I've to show Max quarter,previous quarter and previous year same quarter.
I have to show them in a chart and by default the max value should be shown on the chart.
Thanks in advance.
hi Manish,
thanks for ur help but the value is showing zero in the chart.