+ Reply to Thread
Results 1 to 2 of 2

HELP: add function based on pivot table data

  1. #1
    Registered User
    Join Date
    01-11-2019
    Location
    london, england
    MS-Off Ver
    MS Office professional plus 2013
    Posts
    1

    HELP: add function based on pivot table data

    Ok so one column (x) in my pivot table has numerical data which changes as i change a filter on a different column (y). I want to find the average of the data in column x and display this in a cell away from the pivot table but on the same sheet. I used the forumla =AVERAGE(Table1[x]). However, when i change the filter the cell with the average function doesnt compute change at all or other times it wont compute properly.

    (Yes i edited the headings on the screenshot for convenience)

    Thanks in advance
    Attached Images Attached Images

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: HELP: add function based on pivot table data

    Perhaps try using SUBTOTAL rather than AVERAGE, e.g.:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using VLookUp Function with Pivot Table Data
    By rn_ in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-30-2015, 12:49 PM
  2. Replies: 6
    Last Post: 07-31-2014, 12:56 PM
  3. [SOLVED] Filtering Data Pivot Table is Based On - Impact on Pivot Table
    By bbg22 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-17-2013, 06:34 AM
  4. Countif,Pivot table & Pivot Chart Based on data
    By excelkeechak in forum Excel General
    Replies: 5
    Last Post: 02-27-2010, 11:56 PM
  5. Moving data from a pivot table to another table based on conditions
    By MarinaDBrown in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-22-2009, 12:11 PM
  6. Can a pivot table function like data filter?
    By Tbal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-18-2005, 09:01 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1