Hi,
I have a pivot table based on a range of data which is controlled by Slicers. I have another table to return the values with a vlookup to return the count value if it DOES = a certain month (this year), but I am not sure of how to count the pivot count if it DOES NOT equal the date. (ie, all the rest)
I have attached an example set of data as I don't think I have explained it very well. in essence, I just want a count of the existing data based on the slicer outcome.
many thanks in advance.
Bookmarks