Variance analysis

[#1]

Hi

I am trying to do variance analysis. I have attached a excel sheet of sample data. The variance analysis is Month over Month and Quarter Over Quarter. I already have all the data is my data model

Thanks

Priya

[aarkay29]

Something like this using Set Analysis

sum({$<Date={"<=$(=Max(Date))>=$(=MonthStart(Max(Date)))"}>}Sales)-

sum({$<Date={"<=$(=MOnthEnd(AddMonths(Max(Date),-1)))>=$(=MonthStart(Addmonths(Max(Date),-1)))"}>}Sales)

sum({$<Date={"<=$(=Max(Date))>=$(=QuarterStart(Max(Date)))"}>}Sales)-

sum({$<Date={"<=$(=QuarterStart(Max(Date))-1)>=$(=QuarterStart(QuarterStart(Max(Date))-1))"}>}Sales)

[Peter_Cammaert]

Useful blog post by HIC: Year-over-Year Comparisons

Somwhere along the thread, discussions mention Month-over-month. Q-over-Q can be deduced from there on.