grand total in pie chart of pivot table

[Deleted]

Hello,

I want to display "Grand Total" column data in pie chart but currently it is displaying data from first column.

Pie chart should values from grand total column.

I have attached excel file.

Kindly help!!

Thanks

[#2]

Hi Kinjal,

To my knowledge it's not possible to create Pivot Chart directly on Grand total column. Workarounds could be to add calculated field which shows the same as Grand total and use it for the chart. Or using cube function GETPIVOTDATA to generate dynamic table and use it for the chart.

That question appears from time to time, you may google for sample and/or more details.