I would like to sum all the values in a column in a pivot table.
It's possible for simple tables using the Chart Properties> Expressions> Totals> sum of lines but for pivot table i don't know how to do...
I've tried using the Chart Properties> Presentation> SubT otals, but the results are false...
I put an Excel file attachment. There are comments on some cells.
Thanks a lot for your help
You can try below expression.
In your pivot chart.
i would try but i don't understand...where can i put this expression?
When i use a pivot table, i have only the choice between : "no total", "total expression", or "sum of lines" in the box TOTALS.
first convert pivot into straight
then go to expression and check sum of rows
then again cconvert into pivot table
go to presentation-> show partial sum-> subtotal on top
hope you require this