Dec 11, 2013 at 10:39 AM

# Filter is Based on Two Different merge Dimension

17 Views

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...

Attachments

Quertwise1.JPG (237.1 kB)