I am trying to display the Grand Total in a Pivot Chart using Excel 2013 but this doesn't seem to be working. I have created a Sheet that extracts data from SQL and from this data sheet, I create my Pivot Table and Picot Chart.
I have created a calculated field on the data sheet but this just ruins the Pivot Chart and Table completely because I am doing groupings on that data, so if I add this calculated field on the first row and the first rows Country is UAE, the Chart displays the data only in UAE grouping and the table now just counts the extra fields under UAE and is blank on all other countries.
What is the reason why Excel has excluded the Grand Total from Pivot Charts?
