PDA

View Full Version : Get Value from Pivot table.



yewee
2014-08-13, 03:51 AM
Hi All,

I have a Pivot table that the value and column will change when the filter change.

For example, if i choose certain filter it will should the below Pivot table:

Name SGDUSDTotal


If i choose other value for the filter, it may only show three columns.
For Example:

Name SGDTotal


I have another sheet which i will like to capture the Value in the Total Column of the Pivot table.

Can i know how can i do that?

Thanks in advance.

Bob Phillips
2014-08-13, 11:28 AM
Your question makes no sense to me. You need to be far more articulate explaining the problem and the requirement.

JeffreyWeir
2014-08-19, 02:49 AM
Yewee...for that you can use the GETPIVOTDATA function. Google GETPIVOTDATA, or post a sample workbook here and I or someone will help you out.