pb with the total displayed

[master_student]

Hi everyone,

I really need your help..

I am using a pivot table to show my data. The problem is whene I use the sum function, the amount displayed is not the same when selecting Total de l'expression / Somme de ligne. In my case the correcte amount is displayed when selecting total de l'expression but whene my users extract the table in an excel file and calculate the somme of the amount manually, they don't get the same result

here's my expression sum( POKTND)

I read that it would be better to use the aggr function like this :Sum ( Aggr(  Sum({< $(vSetView)>} POKTND) , LB,Famille,CODE_PROJET,PO_FOURNISSEUR,PO_NUM_COMMANDE,PO_COMMENTS, PO_ACHETEUR,[Month of date], CDR) )

but the result is not correct.

any help please..it's urgent

[vinieme12]

can you share a sample app or sample data?

[master_student]

Hi,

Thank you for your reply.

acctually it works with AGGR function :

Sum ( Aggr(  Sum({< $(vSetView)>} POKTND) , LB,Famille,CODE_PROJET,PO_FOURNISSEUR,PO_NUM_COMMANDE,PO_COMMENTS, PO_ACHETEUR,[Month of date], CDR) )

but the problem is that I am using $(vSetView) to show MTD /YTD / Total year data , they change by the selection :

$(vSetView)=pick(ViewId,

'$(vSetMTD)',

'$(vSetYTD)',

'$(vSetTotal)')

View:

LOAD * INLINE [

    ViewId, View

    1, MTD

    2, YTD

    3, Total Year

];

any help so that my data change with the selection please?

Thanks