+ 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
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    UK
    MS-Off Ver
    various
    Posts
    884

    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)

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