0
I use a lot of Cross Dynamic Tables in Excel for showing my research datas.
I usually want to show a bar chart with error bar as +/- sem and for this I have to ask my CDT for mean, sd and number of my parameter.
Is it possible to ask a CDT directly for sd/root(nb) ?
Dan Chaltiel
Posted 2016-04-22T15:26:50.340
Reputation: 123
1
You cannot calculate Standard Error with calculated fields in a Pivot Table. The calculated fields operate on a "row by row" basis so you don't have access to the correct value for "n" or for "stdev".
You can calculate Standard Error from your Pivot table, however, using the "GETPIVOTDATA" spreadsheet function.
Using this data ...
... I built this simple Pivot Table ...
... then added this calculation nearby ...
=GETPIVOTDATA("StdDev of Data1",A3)/SQRT(GETPIVOTDATA("Count of Data1",A3))
OldUgly
Posted 2016-04-22T15:26:50.340
Reputation: 345
Yeah that's what I've been doing, but it's tedious. I hoped there was another way... – Dan Chaltiel – 2016-04-25T10:46:47.077
Is a CDT the same thing as a pivot table? Are you making pivot charts or regular charts? – Raystafarian – 2016-04-22T15:29:15.663
If you're using a pivot table you can always create a calculated field that calculates what you need it to. – Raystafarian – 2016-04-22T15:29:58.743