I'd like my pivot table to perform a subtotal calculating the average of the visible cells (i.e. not the underlying data) (e.g. average account sales per industry, average of the quarters within a year) I realize the answer is somewhere inside of a power pivot measure but I can't quite figure it out.

Any help would be much appreciated!

something like this (swap what the pivot table is doing for the manual calcs off to the side/below) ![79805-image.png][1]

My data is a flat sales transactions file that looks like this (simplified): ![79795-data.png][1]