Hi everyone!
I need help creating a pivot table. I have no idea where to even start, so any tutorial with basic steps would be great. Also it needs to be a comparison pivot table. So it should look like this:
Current POV Comparison POV
Units/Sales/Margin Units/Sales/Margin
Dealer xxxxxxxxxxxx xxxxxxxxxxxxx
Product Line xxxxxxxxxxxxx xxxxxxxxxxxxx
Model xxxxxxxxxxxxx xxxxxxxxxxxx
Sales Order xxxxxxxxxxxxxx xxxxxxxxxxxxx
The selection criteria need to be dealer name, sales manager, product line, territory, year, and point of view (POV).
I know how to select the dimensions, but that's about it. I don't know where to put them as far as x or y, or what kind of expression to write. Pictures, code, or really anything would be helpful. Thank you!!!
