Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be use Aggr() function
Sum(Aggr(YourExpression, LB, CDR, Famille))
Here YourExpression is a placeholder for your actual expression.
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.
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?
What are these
'$(vSetMTD)',
'$(vSetYTD)',
'$(vSetTotal)')
'$(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 ..