It's almost it, but there is one issue, I want a date field, that I can drag in, and it automatically includes all the months with it. I can then filter the months I want, does that make sense?
Also, for some reason on this pivot table when I drag entries in it automatically makes them SUM formulas, when I do it on my real-life pivot table it keeps defaulting to Count of Jan, Count of Feb, which is really annoying because I have to manually change them back to SUM one by one, I have no idea why it is doing this. Is there a way I make it go back to making SUM the default?
Thanks!
Bookmarks