Standard Deviation Across Column Fields

Hello,

Hope everyone is doing well.

I have been playing around with a pivot table and cannot seem to figure this out. Essentially, I have a pivot table setup with columns as the week, customer and manufacturing plant as the rows, and the data is sum of the demand. What I want to do is calculate the standard deviation of the demand across all the weeks of the year.

I have tried using calculated items, but cannot seem to figure out the arrangement to set it up. Maybe this isn't something that is possible, but I feel it has to be.

Thanks!

It is difficult to answer the question without seeing the data. However, I do something very similar, but I have not found a way to get the results within the pivot table. I have a helper column to the left of the pivot table (since pivot tables expand to the right) with a formula like =IFERROR(STDEV(I13:CA13),0) for every row I am likely to have in the pivot table. For some applications, I overlay the helper columns with named dynamic ranges to eliminate the rows that "error out."

Also in some cases I have a dynamic range for I13:CA13. I always know what cell I want to start in (current row, column I) and I know I want to return just one row, so the only "unknown" is the number of columns that I get counting all the dates in the date row.

I am trying to use calculated items to calculate the standard deviation of customer demand by month (columns). The value field is the demand in lbs and the columns include the plant making the product, the product name, and the customer receieving it

I create teh calculated item as =STDEV.S('1','2','3','4','5',','7','8','9','10','11','12'). When I create the calcluated item with limited row, it calculates in seconds. As soon as I add another field to rows, it hangs up. I can't tell if its actually calculating but taking forever or if its just hung up indefinitly.

If you can obfuscate the data so it isn't sensitive, a sample workbook would help.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.