Regarding Quarter comparision

[#1]

Hello Friends,

I appreciate your time.

I am looking for some help with quarter comparison.

I need to compare current quarter sales vs last year quarter(Same period) . Could you kindly share your ideas!

Thank you!

Kiruthiga

[neelamsaroha157]

You can create two variables fro your current & previous Quarter and use them in set analysis.

Assuming that your Quarter Field format is [Quarter Year]

CurrQuarter  = quartername(Max(Date))

PreQuarter =   QuarterName(quartername(Max(Date)), -1)

[neelamsaroha157]

Sorry

PreQuarter =   QuarterName(quartername(Max(Date)), -1)  will give you last Quarter.

Change it to -- PreQuarter =   QuarterName(quartername(Max(Date)), -4)