Pivot

-  How to check the data source of Pivot?

Ans: Go to PivotTable Tools -> Options - > Change Data source ---- this will tell you the data sources of the table

In a sheet if you have multiple pivot tables it does not mean that they have same data source. If you want to change data source, you can do it here.

- Pivot total counts getting updated on the top and bottom by default, how to get a control on it?

** Grand Totals for Rows
**Grand Totatls for columns
Ans: In PivotTable tools(in menu bar)->Design there are options for Subtotatls and GrandTotatls. Solved.


- How to add extra column to the Pivot table(calculated field)?

Select already created Pivot table, go to Options->Formulas->Calculated field