Filter is Based on Two Different merge Dimension

[former_member221192]

HI,

i have two queries,both having    LO1 call/month that i have merged

first query LO1 call/month containing following values correspondind measuer

04.2013

05.2013

06.2013

07.2013

08.2013

09.2013

10.2013

11.2013

in that above values i have compained 04.2013,05.2013,06.2013}=Q1,,07.2013,08.2013,09.2013}=Q2,,10.2013,11.2013,12.2013}=Q3 for finding Quarter i have  applied following formula

=If([V_MainQuery MonthNo])>="01" And [V_MainQuery MonthNo]<="03" Then "Q4" Else If [V_MainQuery MonthNo] >="04"And [V_MainQuery MonthNo]<="06" Then "Q1" Else If [V_MainQuery MonthNo] >="07"And [V_MainQuery MonthNo] <="09" Then "Q2" ElseIf [V_MainQuery MonthNo] >="10"And [V_MainQuery MonthNo] <="12" Then "Q3"

before doing takeout month number in variable,then above formula i found out

Second Query call/month having following values

04.2013

05.2013

06.2013

07.2013

08.2013

09.2013

10.2013

11.2013

in that above values i have compained 04.2013=Q1,,0,09.2013}=Q2,,12.2013=Q3 for finding Quarter i have  applied following formula

= If([V_OSOD Monthnum])="06" Then "Q1" Else If[V_OSOD Monthnum]="09" Then "Q2"

Else If[V_OSOD Monthnum]="12" Then "Q3" ElseIf([V_OSOD Monthnum]) ="03" Then "Q4" Else "Other

My issues was ,i applied filter based on first query ,it will give the values Q1,Q2,Q3,

second query will give only Q1,Q2

based on first query i have applied filter,

again i have applied formula for taking second Query Quarter it is not giving correct value following formula i used

=[OD]Where([V_osod Quarter]=[V_QuarterMainquery])/100000

but correct value for Q1 is 2713.92, snap shot table2  is correct

plz help,find the snap shot...

[former_member225163]

Hi,

Based on the screenshot, i can found that the output is sum of all quarters. for now, Q1 and Q2 have values so, its Q1+Q2. Please add a condition to restrict respective quarters in each block.

This can be done in two ways.

1) If the block is cross tab then use IN context operator

2) if the block is table then use a condition to restrict to Q1 or Q2 respectively i.e., add a condition like where quarter=Q1 in the highligted cell formula..

Hope this helps..

Cheers,

Bala