Four months trailing total for Quarter

[Anonymous]

Hi

I appreciate your help.

I have attached QV file, in that I need four month trailing(Current Quarter + previous 1 month) total for particular quarter.

Please have a look on attached QV file

Thanking you for your time and efforts

[#2]

Create a new column, if((Month=Dec, Jan, Feb, Mar, Apr), Q1, if((Month= Mar, Apr, May, Jun), Q2, ........!! Use it as a dimension and sum it. Hope this works.

Suraj

[Anonymous]

Suraj,

My quarter is going to be the same Jan-Feb-Mar than Q1, Apr-May-Jun than Q2

But with in this quarter I need four trailing month sum for division

Thanks

[arjunkrishnan]

Hai Satish ,

I try This One I hope U I will vry Useful for ...Pls find my Qvw...

O/p Like That

I Should Little bit Changes Happen On U r App ..Pls Show THis

[Anonymous]

Arjun/ Suraj

I appreciate your efforts

Let me try this and I will update

Thanks again

[Anonymous]

Hello Arjun

With particular selection it works fine but without selecting any year/quarter there is no value in row

Because with selection it become static, in this case dimension is variable

Thanks for your effort