Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a problem on the partial sum of my size in my PivotTable, because I do not understand why we are not done on all lines.
As shown in the pictures attached:
Thank you in advance for your help.
Wishing you a good day,
Cocalero.
It will be depend on the kind of your expression if you get a partial sum. An expression like sum(AnyField) will nearly always work but something like quantity * price won't - for such kind of expression you need a wrapping with aggr, something like this: sum(aggr(quantity * price, YourDimensions)).
- Marcus
Thanks for your return Marcus Sommer,
But I do not understand why the partial sum does not work 😕 (This is the first column of the photo attached to my first post), it works only for the third line.
Please provide a screenshot where the dimensions are visible and also how the expressions look like.
- Marcus
Hello,
Here attached the pictures requested:
However, the sum does not have expressions but I just activate the partial sum in the options.
Thank you again for your help !
But you must have an expressions within the tab expressions - how looked they?
- Marcus