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
Bookmarks