Can you get the sum of a column in a pivot chart?

[#1]

Can you get the sum of a column in a pivot chart?

[MK_QSL]

Presentation Tab

Select your Dimension and Tick Show partial sum

[#3]

What if it is an expression?

[MK_QSL]

Once you select the above suggested method, it will automatically applied to Expression Total also.

Just try it and let us know if you found any problem.

[#5]

Is there a way to change the format of a dimension? I have numeric values that I want rounded to a whole number.

[#6]

how do you want to round them?  The use of ceil() and floor() along with the num functions will take care of that for you

[MK_QSL]

Yes,,,

Use calculated Dimensions

NUM(YourDimension,'#,##0')

[Clever_Anjos]

Two ways of doing that

1) go to Document Preferences / Numbers Tab and select/format your dimension

2) Change your dimension into a formatted calculated dimension, eg:  num(yourvalue,"###0.00")

[gerhard_jakubec]

"Show partial Sum" always derives the expression total which is not equal to the sum of rows or columns except if your expression = sum( [fieldName] ) !

[MK_QSL]

We can obviously use =SecondaryDimensionality() to get the same...