Hi all, I'm sure this has been addressed in general, but I hope you will forgive a new forum member asking it again. I tried searching.
I'm using Pivot Tables. When I set the Pivot Table fields, you can choose the source field, and the formula under "summarize by". The formulas available only include average, stdDev, and a limited number of others. How do you create a custom formula for "summarize by" to apply to a source field. The specific formula I want to use would take the standard deviation and the count of the data and generate a standard error of the mean. If I were to enter the formula in a regular cell it would appear as:
=StdDev(A1:A10)/SQRT(count(A1:A10))
I have looked at the custom formula options under the pivot table dropdown but they don't make any sense to me.
It would really help if someone could answer this for me.
I'm using Pivot Tables. When I set the Pivot Table fields, you can choose the source field, and the formula under "summarize by". The formulas available only include average, stdDev, and a limited number of others. How do you create a custom formula for "summarize by" to apply to a source field. The specific formula I want to use would take the standard deviation and the count of the data and generate a standard error of the mean. If I were to enter the formula in a regular cell it would appear as:
=StdDev(A1:A10)/SQRT(count(A1:A10))
I have looked at the custom formula options under the pivot table dropdown but they don't make any sense to me.
It would really help if someone could answer this for me.
