Search results

Narayan, It seems like a very tedious solution and it won't scale for my requirement; at least I don't think so. I may have to settle for a normal table. Thanks. Jaya

Sajan, I have posted the workbook here: https://docs.google.com/open?id=0BxXeZvAvqG3ja1FITkxFd2RoRkk The first worksheet contains anonymized sample data. The 2nd worksheet shows the Pivot table and chart, and you can see Overall (which is the Grand Total) does not appear in the chart. I...

GetPivotData gets me the value of the Grand Total, which is good starting point. How do I include that value within the Pivot Table in a calculated field so I can plot it in the Pivot Chart?

I googled the topic first and I just refused to believe that this was not possible! I assumed that there must be a workaround using 'calculated field' and I was hoping someone had already cracked this problem before. I am still hoping that it can be done. The trouble with normal charts is...

I am doing a simple summary of survey data using Pivot Table. The Pivot Table contains all the data I need to make comparisons of say Eastern, Western, North, South and Grand Total. When I create the Pivot Chart, the Grand Total column does not appear, but I want to able to compare Eastern vs...

I want to include the Grand Total Row in my charts. The data I am using is from a survey. When I create the Pivot Table it shows the Grand Total, but the Grand Total will not appear in the Chart. From what I have read, I am supposed to use a calculated field, but I am just not able to do so...