I have a pivot as follows with the expression:IF(min(Month_name)>=(vCurMonth),Sum(Sal*Bench_Data),Sum({<Y={'2015'}>}Fact_bench))-Sum(Budget)
Quarter
Q1
Q2
Q3
Q4
BG_bench
Rest
Rest of Budget 2015, USD
Bench 2015 vs Budget 2015, %
Rest of Budget 2015, USD
Rest of Budget 2015, USD
BG1
-61640
-33,992
-82%
-95,706
-146,370
BG2
0
2,184
0%
1,344
1,512
BG3
1
10,296
0%
6,336
7,128
BG4
2
5,616
0%
3,456
3,888
BG5
3
8,424
0%
5,184
5,832
BG6
4
0
-
0
0
BG7
5
5,616
0%
3,456
3,888
BG8
6
2,496
0%
1,536
1,728
Total
640
-1%
-74,394
-122,394
I want ot create a calculated dimesion with the rest of budget for the year: Aggr(IF(min(Month_name)>=(vCurMonth),Sum(Sal*Bench_Data),Sum({<Y={'2015'}>}Fact_bench))-Sum(Budget),BG_bench)
