Need Calculated "Grand Totals" (but other calcs) in a Pivot Table | Dashboards & Charts | Excel Forum

 I have turned my data into a pivot table with sku#s on the rows and dates on the columns and then that sku's actual sales for that particular date.

I do not want the "grand total" of each row, but I do want the "st.dev" of each row as well as the "ave" of each row and 1-2 additional calculations of each row.

I have been successful in using the calculated field function, but this brings up a new column for every date when I only need one column summarizing the calculation of all the data at the end of the rows.

I've attached a .pdf screen shot of how I want it to look (keep in mind I've hidden several data rows simply to allow you to see the calculations that I am hoping to achieve at the end/summary of the pivot.

There is going to be ever changing data in this document - the pivot data is derived from a linked Access Table that will continue to have items added or deleted and will be a rolling ~6 months of data, so I don't know that simply adding a column at the back end with the formulas would do the trick. If it really is this simple and I'm over-complicating it, let me know, but I feel like there's got to be a way to include it in the pivot table...