excel - Further Summarize Pivot Table Results (Average) -

this seems should simple, can't figure out morning. i've had coffee. returning 4 fields webfocus query: shipweek, ship date, part numberand quantity (qty). set query pulls 365 days of records when workbook opens. have summarized data pivot table. pivot table shows shipweek row 2 values: count of qty , sum of qty. works fine.

what want beyond this, however, calculate range of returned results average weekly count , standard deviation. can using average() , stdev() functions , pointing 2 values ranges in pivot table. work once. i'd not have manually adjust range these formulas each time run query. theoretically, there same number of weeks in 365 days of data, may not case. if number of rows in pivot table changes, might skew results.

surely there way in pivot table itself? pivot table offers "grand total" option, sum of records, don't know how equivalent of "grand total" average or standard deviation.

if not in pivot table, dynamically outside of pivot table without requiring manual range updates each time?

i think (though i'm not sure) answers question. in pivottable builder, select value trying calculate, , click on detail button (so in image below, little "i" next appropriate item in "values". select function want instead.