Apr 13 2018 12:57 PM - edited Apr 13 2018 03:55 PM
Apr 13 2018 12:57 PM - edited Apr 13 2018 03:55 PM
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
Apr 14 2018 04:06 AM
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.