Calculate standard desviation in a pivot table

[#1]

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!!

[tresesco]

Try:=Stdev( Total <Month> [Quantities of supllies])

Attached qvw

[#3]

A question, the field [Quantities of suplies] in fact is another expresion:

  count (DISTINCT [Nro. Entrega])

[tresesco · Accepted solution]

Then try like:

Stdev( Total <Month> Aggr(count (DISTINCT [Nro. Entrega]) , Month, [Order Number]) )

[#5]

Show all in 0 zeros.

[tresesco]

Could you share sample app with sample data?

[#7]

Sorry, finally it worked. Thank you!!!!!

[lawrenceiow]

tresesco, I have been given a link to your answer (posted here) by Oswaldo Vasquez as he has suggested that it will help me with the problem I have with StDev, as described here: Re: Why does my Avg expression not work (I mean how do I get it to work)

I have tried modifying your answer for my problem but it does not seem to work. Would you mind taking a look at my post?

Thank you

Lawrence