Forum Discussion
Pls help me create Pivot Table example
mathetes wrote: ``I did your first PT``
Thanks. I hope someone can provide PT 2 with explicitly-rounded values or formulas (calculated fields?).
I hope it's not =ROUND(SUMIF($B$4:$B$25, H4, $C$4:$C$25), 3). That would seem to defeat the purpose of using a PT. (Perhaps because my example is too simple.)
Yes, I know that PTs are most useful with more complex data and designs. But when I create examples for educational purposes, I like to KISS. "Everything should be as simple as possible, but not simpler." (wink)
I hope it's not =ROUND(SUMIF($B$4:$B$25, H4, $C$4:$C$25), 3). That would seem to defeat the purpose of using a PT. (Perhaps because my example is too simple.)
Bingo! Take that "perhaps" seriously: If you can get from point A to point B by doing a formula such as you've written, why make it more complicated? The purpose of a Pivot Table comes into play when the data you're dealing with, the summary you're seeking, can't be as simply resolved with a single simple formula. One of the wonderful features of Excel is that there are frequently (I would even say "usually") several ways to get from point A to point B; so unless the way you've found is convoluted, there's not a lot of reason to go looking for another.
Yes, I know that PTs are most useful with more complex data and designs. But when I create examples for educational purposes, I like to KISS. "Everything should be as simple as possible, but not simpler." (wink)
There is complex and there is complex. The example I sent you is NOT particularly complex; it just has another dimension to it and, as such, is a good simple example of where the Pivot Table helps summarize data: it creates a two dimensional array. Your examples are so simple that they don't need the Pivot Table tool.
By the way, did you even look at the resources I pointed you to?