Total or calculated dimension in pivot

[#1]

Hi, Qlikview profis.

I have a tricky problem here. I have a pivot with the following expression:IF(min(Month_name)>=(vCurMonth),Sum(Sal*Bench_Data*Forecast),Sum({<Y={'2015'}>}Fact_bench)) . I need the total of it, but the problem is that total isnt calculated properly. I try to create a calculated dimension but at the end I get the same problem.

Here is my sample attached. Please help!

[rubenmarin · Accepted solution]

Hi Diana, try with this expression:

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

And also change vCurMonth to:

=Num(Month(Today()))

[#3]

HI!

Great, thanks!