topic Re: previous quarter in Water Cooler

previous quarter

Anonymous — Thu, 06 Mar 2014 07:19:37 GMT

how to find the previous quarter of the max year.i have to find the previous quarter of the max year having current quarter.

MK_QSL — Thu, 06 Mar 2014 07:25:58 GMT

=SUM({<Date= {'>=$(=QuarterStart(Max(Date),-1))<=$(=QuarterEnd(Max(Date),-1))'}>}Sales)

Thu, 06 Mar 2014 07:31:44 GMT

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

Anonymous — Thu, 06 Mar 2014 07:36:41 GMT

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.

Anonymous — Thu, 06 Mar 2014 07:37:24 GMT

hi Manish,

thanks for ur help but the value is showing zero in the chart.