I have a STDev MDX Calculated measure to create.
I have the following dimensions:
Job Family [3 Members]
Job Titles [120 Members]
I have the following Measures:
Pay Rate What we pay our Associates
Bill Rate What we Bill our Customers
Associates People we place in jobs
I have created Bill Mean Calculated Measures [sum(Bill Rate)/Count of Associates] same for Pay Rate Mean . This works just fine.
I want to show:
Pay Rate Low Pay Rate Mean Pay High Pay Rate
STDev – Mean Mean STDev + Mean
Same report for the Bill Rate.
I am having trouble conceptualizing how to go about creating the STDev.
What I have currently :
For Straight STDev of Bill Rate
Stdev([Job Family].[Job Title Name].members,[Bill Rate Mean])
This yields a result that seems to be uniformly applied across every Job Title.
I need it to be a unique calculation for each Job Title.
Stdev(«Set»[, «Numeric Expression»])
Stdev(«Dimension».CurrentMember[, «Numeric Expression»])
Stdev([Job Family].[Job Title Name].CurrentMember[, «Numeric Expression»])
For «Numeric Expression» do am using the raw [Pay Rate] value.
With the above MDX Expression, I am seeing ONE value calculated for all of the Pay Rate Column , likewise with the Bill Rate Column.
As you can see I am a bit confused about how to proceed.
Any help would be greatly appreciated.