Partial Sum in PivotTable

[Anonymous]

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.

[marcus_sommer]

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

[Anonymous]

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.

[marcus_sommer]

Please provide a screenshot where the dimensions are visible and also how the expressions look like.

- Marcus

[Anonymous]

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 !

[marcus_sommer]

But you must have an expressions within the tab expressions - how looked they?

- Marcus