Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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):
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):
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.
You probably need to create a new expression. Someting like expression1 + expression2...
Nicole Smith i tried it again, and your suggestion worked. Thank you very much
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.