Minning and Maxing in Pivots
By Tim Dexter-Oracle on Jul 15, 2013
A tricksy question from a hobbiteses this past week or so. How can I use minimum or maximum in an RTF template pivot table?
Using the pivot table dialog box, you get sum or count. So, how to get a min or max? You need to understand the pivot structure a bit to understand how to get the min|max. I wrote about the pivot table format a few years back here.
Its the C field that holds the calculation as the last parameter.
I was not sure if we could simply swap out the sum|count function for our min, max functions. But, Im a hacker at heart, so I gave it a whirl. It worked, I used the BIP min and max functions:
They both work nicely!
So, the C field would look like:
If you do not need the default totals (that use the functions you define.) You can just delete them from the table.
Sample template and data here.
Now, the average values need cracking!