Create total column in pivot table Chart

[#1]

How do I create a Grand total column in pivot table chart?  Just like a Grand total column that shows while using pivot tables in Excel.

[Nicole-Smith · Accepted solution]

You should be able to get this by putting a partial sum on the first dimension in your pivot table (you can also change the label if you'd like):

[#3]

Thank you for responding Nicole.  But I was wanting a vertical totals column.  Your suggestion above, gives me a horizontal total in a row.  My BP is wanting a grand totals column.

[#4]

You probably need to create a new expression. Someting like expression1 + expression2...

[#5]

Nicole Smith i tried it again, and your suggestion worked. Thank you very much

[#6]

Pavol Hajastek thank you for taking time to respond.  for now I used Nicole Smith's suggestion. Have a great day.  Appreciate your willingness to share your knowledge.