Month vs Quarter

[#1]

Hi, guys!

I have a tricky problem here. I have a pivot table as follows:

Months	Q1	Q2	Q3
BG_bench	Bench, USD	Bench, USD	Bench, USD
Engineering	30,864	0	0
Genesys	0	0	0
International Other	0	0	0
Kyivstar	0	0	0
Lindorff	0	0	0
Telecom	0	0	0
Ukraine other	0	0	0
Total	30,864	77,420	180,906

I have a condition for Becnch USD calculation depending on the period, if it is > or < than current month

My expression:

IF(Month_Date>=(vCurMonth),Sum(Sal*Bench_Data),Sum({<Y={'2015'}>}Fact_bench))

However when it comes to quarters it doesnt give me the desired result.

The quarters are in the same table with Month_Date in my load script.

Thnx!

[Anonymous]

it would be great if you can share sample qvw

[mohammadkhatimi]

Hi...Diana...

Please post a sample application...

Regards,

Mohammad.

[PrashantSangle]

Hi,

Try with below expression,

IF(Month_Date>=(vCurMonth),Sum({<Month_Date={">$(=vCurMonth)"}>} Sal*Bench_Data),Sum({<Y={'2015'},Month_Date={">$(=vCurMonth)"}>}Fact_bench))

Regards

[#5]

Hi,

Unfortunately, this doesnt work

[#6]

Hi, 

How can I add a document here? cant find a button

[#7 · Accepted solution]

maybe this will work?

IF(min(Month_Date)>=(vCurMonth),Sum(Sal*Bench_Data),Sum({<Y={'2015'}>}Fact_bench))

[Anonymous]

on right top of reply box see blue link use advanced editor click that and then on right bottom you will get link to attach files