logice

[smilingjohn]

Iam trying to use this in a dimesion .

Can please someoen guide me if this is wrong ...

=If(match(Right(monthname(Created),4),$(vPrevYr),$(vPrePrevYr)),MonthName(Created))

vCurrYr =Year(Max(Created))

vPrevYr=Year(AddMonths( Max(Created),-12))

vPrevPrevYr=Year(AddMonths( Max(Created),-24))

In my dimesion i want to bring  show 24 months data Like (jan-2015, Feb-2015......tll date )

to achieve this this iam trying to do the abive part ..

Thanks in advance

[prma7799]

Please check variable vPrevPrevYr=Year(AddMonths( Max(Created),-24))

=If(match(Right(monthname(Created),4),$(vPrevYr),$(vPrePrevYr)),MonthName(Created))

[smilingjohn]

Hi PAM

Is there something wrong in this ..

I mean what should I do ...What do I need to correct

[mdmukramali]

Hi,

it seems the error in the variable name.

=If(match(Right(monthname(Created),4),$(vPrevYr),$(vPrePrevYr)),MonthName(Created))

vCurrYr =Year(Max(Created))

vPrevYr=Year(AddMonths( Max(Created),-12))

vPrevPrevYr=Year(AddMonths( Max(Created),-24))

Updated:

=If(match(Right(monthname(Created),4),$(vPrevYr),$(vPrevPrevYr)),MonthName(Created))

Thanks,

Mukram

[smilingjohn]

Hi mukhram

I changed th variable names accordingly

But the error is still seems to be the same ...

Can you ease give me an example of he same as a sample ...It will really great helpufull for me

[mdmukramali]

Hi John,

can you share your sample data and expected output so it will be helpful for us as well as You also.

[techvarun]

Do you have data in Created column for all the months?

Then Use =Month(Created) in dimension

and in the dimensions limit tab show only largest 24 Values

!

[techvarun]

Or use this formula in Dimention

=If(match(Right(monthname(Created),4),$(vPrevPrevYr),$(vPrevYr)),MonthName(Created))

[smilingjohn]

Hi,

Please find the attachment of the QVW file

[mdmukramali · Accepted solution]

Hi,

find the attached file.