Hi there,
Is there anyway to show the maximum, minimum, and average value for the rows in excel? I know we can do this for the columns.
Another question is there anyway to reference the subtotal? Every time I refer to the subtotal in pivot table, I got #N/A.
Thanks.
I have attached an example as the forum requested.
Bookmarks