Results 1 to 3 of 3

Thread: Get Value from Pivot table.

  1. #1

    Get Value from Pivot table.

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    Your question makes no sense to me. You need to be far more articulate explaining the problem and the requirement.

  3. #3
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    New Zealand
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts