pivot table sum problem

[#1]

Hi all,

I am trying to get the sum of the pivot table expression:

Total + if(b.Year= Year(vTODAY) and num(b.MonthName) >= num(Month(vTODAY)),Forecast,0)

Where Total and Forecast are two other expression.

And my dimentions are b.CustomerClassDescription,b.ProductClassDescription,b.CustomerName,b.YearMonth

It seems corrent on an individual month basis but the acutal total number is wrong.

Can anyone help??

[tresesco]

Could you post a sample that demontrates the issue?

[#3]

Hi there here is a sample image.

What i actually want is to the FY13Estimate to be the Actual + Forecast for (November and Decembe)

[tresesco]

Your expressions and dimensions would play a big role to suggest a solution. Please refer Preparing examples for Upload - Reduction and Data Scrambling and share your sample app.

[#5]

Oh have not seen that, I will have that in mind next time.

I finaly managed to solve the issue but the expression is a bit compicated to post.

Thanks for the helping anyway