QTQ comparison

[#1]

Hi all

can anyone help me how to compare the quarter to quarter...

i.e., selecting the 2nd month in Q1 will compare to the 2nd month in preceding quarters

thanks in advance

[#2]

hi gopinathanl

i m not cleare about ur question.

make a inline table like this:

Month_Map:

LOAD

* INLINE [

Month, Quarter

Jan, Q1

Feb, Q1

Mar, Q1

Apr, Q2

May, Q2

jun,Q2

Jul,Q3

Aug, Q3

Sep, Q3

Oct, Q4

Nov, Q4

Dec, Q4

];

then make your chart by first dimenssion Quarter with ur expression.

try this

thanks

zaman

[#3]

To get the relative month within the quarter, use the following formula :

Example : July = month 7 in 3rd quarter. July is the first month within 3rd quarter

Formula = num(month(<datefield>)) - (num(quarter(<datefield>))-1)*3

On the example : 7 - (3-1)*3 = 1

November for example would lead to : 11 - (4-1)*3 = 2

That should do the trick.

You will now be able to select the relative month within the different quarters