Displaying Pivot Table Column outside Pivot Table

Displaying Pivot Table field outside Pivot Table

In my Yesterday post i showed  how to display sum of Pivot Table column oustide Pivot table

In this Post i will show you  how to display pivot table field (Not Sum) outside Pivot table.

For This we have an excel formula GetPivotData.

We will use the Previous blog to create pivot table

Creating Excel Pivot Table using SQL Database

http://sqlandssrssolutions.blogspot.in/2013/12/creating-excel-pivot-table-using-sql.html

Slicers to Filter data of Pivot Table in Excel

http://sqlandssrssolutions.blogspot.in/2013/12/slicers-to-filter-data-of-pivot-table.html

Using the same above Pivot table and slicers to demonstrate the Solution to Display Pivot Table field outside Pivot Table.

Now suppose we want to display Raj salary  based on EmpName Raj salary (8000)

in Top row third fifth column i have to display Raj Salary so here is the formula 

=GETPIVOTDATA("Sum of EmpSalary",$A$2,"EmpName",A4)

Sum of Salary- Is the the pivot table column whose value to be displayed

$A$2-Cell of Pivot Table

EmpName-Is the column based on value to be displayed

A4-Is the Cell whose value to be displayed(Raj).

You can add Multiple fields data in GetPivottable by adding fields and item Name,

In order to display Grand Total outside Pivot Table Read my Previous blog.

Displaying Pivot Table Column Sum outside Pivot Table 

http://sqlandssrssolutions.blogspot.in/2013/12/displaying-pivot-data-sum-outside-pivot.html