Pivot on THIS.

[plonq]

It's always a pivot table. There are so many better, more meaningful ways to present the data, but they always ask for it in a pivot table. There must have been some management-level Excel course that they all took a few years ago, where they said, "The best way to present this single, isolated case would be a pivot table. Naturally you have to tailor your reporting for blah blah blah"

"Hm... pivot table. If it works well for this, it will work well for everything. Christ, is he still talking? I have a 2:00 tee time!"

I sent them a sample pivot table of the data, and as inevitably as the sun rises tomorrow they will send it back in the next day or two.

"Could you please make the following changes to the pivot table to present the data [in a manner that pivot tables don't support]?"

Comments

[fuzzytoedcollie.livejournal.com]

If you rotate the first letter, then
pivot table becomes divot table, which matches up with their golfing interests (and abilities) more readily :)

FOUR!

[pfcottontail.livejournal.com]

If ozgrid likes it (http://www.ozgrid.com/Excel/excel-pivot-tables.htm), how bad can it be?!?

PS: Ozgrid is where I learned to code VBA. I am a shitty VBA coder still, but it got me at least part of the way there!