Month-on-Month comparison

[#1]

Hi,

I would like to calculate the Month-on-Month variant in the pivot table I created.

How should I go ahead doing this?

[#2]

Yes,

and also the change in Feb 2014 to Feb2015 as the Y-o-Y change.

[kamalqlik]

Hi Gerald,

Use this function

Floor(Monthstart(Date ))  as MonthYear and upload the QVW again.

I will provide you the solution.

Regards

Kamal

[kamalqlik]

Hi Gerald,

I was waiting for your reply...

I am mentioning the point that you have to do in your QVW.

1) Make a filed MonthYear at backend as

Floor(Monthstart([DATE REPORTED]))  as [MonthYear]

2)Reload the Application

3) Make an variable for this year MaxDate ie Feb2015

vMaxMonth= Floor(num(Max( [MonthYear])))  for Feb 2015

vMaxMonthLastYear   =Floor(num(AddMonths( Max([Month Year]),-12)))

Than add two expression one for this year and one for last Year

Expression 1)  Count({<[MonthYear]={$(vMaxMonth)}>}[Claim No]).... This will give data for feb2015

Expression 2)   Count({<[MonthYear]={$(vMaxMonthLastYear)}>}[Claim No])..... This will give data for feb 2014.

I hope it will help you.

Regards

Kamal

[#5]

Here  is the reloaded attachment with changes made.

[#6]

Attached I have added the results that I am trying to show, but done in excel.

see last two columns, highlighted in yellow.