GAP

[master_student]

Hello Guys,

My pb is the sum displayed on QV is not equal to the sum after exract excel

!=

I am using a pivot table with 3 dimensions LB/CDR/Famille. whene I delete the CDR dimension, the amount becomes correct.

How can I fix that pb.

Thanks

[sunny_talwar]

May be use Aggr() function

Sum(Aggr(YourExpression, LB, CDR, Famille))

Here YourExpression is a placeholder for your actual expression.

[Or]

It's very difficult to guess what your problem is, since you have not posted any actual information, just a screenshot of your totals. My best guess - you have "Supress when Value is Null" on the CDR dimension, and one or more rows do not have a value for this dimension.

[master_student]

Bellow the expression I am using:

sum( {< $(vSetView) >} $(vBudgetReceprionFcst) )

whene applying your suggestion. there's no value..

vSetView=pick(ViewId,

'$(vSetMTD)',

'$(vSetYTD)',

'$(vSetTotal)')

vBudgetReceprionFcst = pick(TypeID,

[Budget RECEPTION FCT]  ,

[Fcst 3+9 RECEPTION FCT],

[Fcst 6+6 RECEPTION FCT],

[Fcst 9+3 RECEPTION FCT])

Any idea, please?

[Anil_Babu_Samineni]

What are these

'$(vSetMTD)',

'$(vSetYTD)',

'$(vSetTotal)')

[master_student]

'$(vSetMTD)'= [Calendar date]=  ,   [Month of date]={ "= $(=max([Month of date]))"},  [%Date ID] = { "<= $(=max([%Date ID]))"}

It 's month to date/year to date / Total year ..