Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 Thank you, I found the solution thanks to you:
the expression in dimension:
aggr(sum({<Mouvement_ID={'Achats'},Année=, Mois=, Groupe=>} Prix), Article)
@Mahmoud try changing pivot table expression as below
= sum(aggr(YourExpression, Dimension1,Dimension2,Dimension3))
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))
)
@Mahmoud can you share sample file to look at?
Excuse me but i'm not allowed to do that, i'm not an administrator
@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)