There is a way to display criteria used to autofilter lists (by VB code) but it doesn't work with filtered Pivot tables (on labels or values). IE this code won't display the filter criteria.
Does anyone know how to do this for a filtered pivot table, or have VB code ?
What i want to do is be able to display the criteria on a pivot chart. (eg. filtered for values between x and y).
Thanks
Does anyone know how to do this for a filtered pivot table, or have VB code ?
What i want to do is be able to display the criteria on a pivot chart. (eg. filtered for values between x and y).
Thanks