pivot table values help

[kobiianardo]

hello i have a table like the following that that i pivotted

original table (two columns, one a#, second its weight)

A# weight
a1 13
a1 13.5
a1 11.3
a2 7
a2 9
a3 25


is there a way for pivot table to do (two columns):

A# stdev(weight)/avg(weight)
a1 0.1
a2 0.17
a3 0


thanks

 

[Lidsavr]

kobiianardo,
Microsoft posted information in their support knowledge base about your question. Please view it at: http://support.microsoft.com/kb/152984

Best of luck,

Charles

 

[kobiianardo]

thanks lor, it looks like the article in the knowledge base was doing this:

columnA: quarter
columnB:
stdev(quarter-x-revenue-thisyear)/stdev(quarter-x-revenue-lastyear)
columnC:
avg(quarter-x-revenue)


i'm looking for a way to calculate the "standard deviation as a percentage of the mean". i think this requires me to be able to directly do something like this on a PT:

columnA: groupID
columnB: average of weights grouped by ID
columnC: standard deviation of weight grouped by ID
columnD: divide column C by D

incidentally what i want is something like this simple SQL statement:
select groupID, Stdev(weight)/Avg(weight) from a_table_i_made group by groupID



it's not hard to do if i just copy the pivot table's value elsewhere and apply a formula, i'm just curious if there's a consistent way with PT to do this