7 Replies Latest reply: Aug 7, 2014 9:21 AM by Lawrence Cooper RSS

    Calculate standard desviation in a pivot table

    Andres Quinteiro

      Hello everyone! I need to calculate the standard deviation with stdev() function in a pivot table. In the table I have the dimensions Month, Order Number, Quantities of supplies. I want to calculate the standard deviation of the quantities of supplies for the month that is appropriate for the dimension. An example:

       

      Month Order Number Quantities of supllies     Standard Desviation

      1               23839                          9                                      stdev(9, 1, 3, 5)

      1               90202                          1                                       stdev(9, 1, 3, 5)

      1               20293                          3                                       stdev(9, 1, 3, 5)

      1               20482                          5                                       stdev(9, 1, 3, 5)

      2               50607                          2                                       stdev(2, 10)

      2               40693                         10                                      stdev(2, 10)

       

      The standard desviation for moth 1 will be stdev(9, 1, 3, 5)

      The standard desviation for moth 2 will be stdev(2, 10)

       

      Thank you!!