Probleme Calcul Total TCD

[Mahmoud]

Hello, I want to add the total column, I added it by "presentation" -> "show partial sums", but it does not calculate the total

the expression

[Kushal_Chawda]

@Mahmoud  try changing pivot table expression as below

= sum(aggr(YourExpression, Dimension1,Dimension2,Dimension3))

[Mahmoud]

Thnak you @Kushal_Chawda ,

when i make it in dimension i have this error 

and when i make it in expression, i have this

my expression:

=If(
((Sum({<Mouvement_ID={'Ventes'}>} Quantité) = 0)
and
(Sum({<Mouvement_ID={'Achats'}, Année=>} Quantité) > 0))
,
Sum(aggr(sum({<Mouvement_ID={'Achats'},Année=, Mois=, Groupe=>} Prix), Article, Groupe))
)

[Kushal_Chawda]

@Mahmoud  can you share sample file to look at?

[Mahmoud]

Excuse me but i'm not allowed to do that, i'm not an administrator

[Mahmoud · Accepted solution]

@Kushal_Chawda  Thank you,  I found the solution thanks to you:

the expression in dimension: 

aggr(sum({<Mouvement_ID={'Achats'},Année=, Mois=, Groupe=>} Prix), Article)