After some research I think I need to use the Offset function - but I can't get that to work as I, presumably, need to specify all the rows which is not very desirable because it's about 7000 rows. Anybody that know how to return values from a filtered pivot table?