I have two worksheets each with similar to below (worksheets are based on year):
A B C 1 Client Name Date Staff 2 Widgets, inc. 10/3/2018 John 3 Microsoft 2/17/2018 Sue
For the pivot chart, I would like the axis (staff), value (count of client), and legend to be date (and broken down to years, quarters). This is how it looks with a pivot chart for one worksheet. I would just like it to combine the data from two instead.
Bookmarks