I am thoroughly enjoying the pivot command. A few aspects that could make it even more powerful:
a) I often use the “Select underlying rows” from a r-click on the bar and copy the data to a spreadsheet to do some temporary check/computation. Instead of having to r-click a bar to get to this function, could this be made to work from an r-click on the applicable row in the little data table also? (Often my pivot/bars are hidden).
b) It would be very nice if we could extract more than a single calculation from a pivot. Often I like a table with min/max/mu/sigma, one of which I may plot with the pivot’s bars though most of the time I just extract the data to rows/columns to use a line plot or other computations before plotting. Right now this takes multiple pivot commands that are essentially the same and only switch the Calculation parameter.
c) I end up having quite a list of pivots in some of the projects. It would be nice to be able to give them a description that can be read when the command is collapsed. Right now I have to open each to see and digest the set up for a few seconds to figure out which one I want to work on.