Immediate apologies if this has been covered elsewhere, but can't find it if it has.
As shown on the attached, Database has Date Received (Col C), Sales person (Col N), Product (which can be in Cols AA, AB or AC) and Contract Value (Col AD).
Can't manage to create a Pivot Table from these. Tried combining the columns into one range, but received an error message.
Hopefully someone can explain how to do this, or suggest an alternative approach?
Once I have the Pivot Table I can add the Date Span and Slicers allowing the choice of Values, Products and Sales people, and show the result as a Pivot Graph.
All solutions, suggestions and pointers accepted gratefully
Ochimus
Bookmarks