Pivot tables - learning the weird and funky bits

[cornflakegirl]

I want to know more about pivot tables. I probably know them to intermediate level - I can group dates, and do "Difference From" fields. But I've only recently learned about the Top 10 thing - and the other day Andrew Poulsom taught me that you can subtotal an innermost row field just by using Custom subtotal.

Where can I learn more? I want to know what my unknown unknowns are!

 

[Richard Schollar]

Hi Emma

Check out the pivot Table Recipe Book by Debra Dalgleish. It's the best book on Pivot Tables there is.

 

[cornflakegirl]

Cool - might try to convince our L&D department to buy that then...

Are there any good websites?

 

[Richard Schollar]

Debra's onw site is www.contextures.com (I think - have lost all my Favourite links since I moved jobs this week).

 

[Jon von der Heyden]

Debra's site is www.contextures.com. Loads of good tips, but unfortunately nothing on calculated items, calculated fields and show pages (as far as I can see anyway). Those are 3 funky features of a pivot table.

An John Peltier explains how to avoid those ugly pivot table charts here and here.

Edit: Found the 3 cool features. Check out Nick Hodges site here.

Regards
Jon

 

[cornflakegirl]

I didn't know about calculated items or show pages - thanks for that!

 

[cornflakegirl]

Just wanted to say - I got the book, and I'm working my way through it. It's very helpful, so thanks for the advice.