Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Arjun/ Suraj
I appreciate your efforts
Let me try this and I will update
Thanks again
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