T tomas Active Member May 21, 2015 #1 Hi in the attachement I explained what I need. Basically need to use in calculation of calculated field a column value which in field settings is set to standard deviation. I need use SD not default sum in calculation Attachments calculated field.xlsx calculated field.xlsx 21.2 KB · Views: 0
Hi in the attachement I explained what I need. Basically need to use in calculation of calculated field a column value which in field settings is set to standard deviation. I need use SD not default sum in calculation
D dourpil Member May 21, 2015 #2 Unfortunately, SUM is the only function available in Pivot Tables calculated fields AFAIK. See this page for more infos: http://www.contextures.com/excel-pivot-table-calculated-field.html
Unfortunately, SUM is the only function available in Pivot Tables calculated fields AFAIK. See this page for more infos: http://www.contextures.com/excel-pivot-table-calculated-field.html
