i am attching sample excel file and i have and it is a straight table
expression1(member count): count(Distinct memnbr)
expression2(inpatient): sum(costinpatient)/count(Distinct memnbr) // [costinpatient also a dimension]
No i need to write two more expressions :
mean of expression 2(inpatient)
stdev of expression2(inpatient).
Thank in advance
=Avg( TOTAL ( sum(costinpatient)/count(Distinct memnbr) , YourChartDims ))
=Stdev( TOTAL (sum(costinpatient)/count(Distinct memnbr) , YourChartDims ))
Replace YourChartDims with your chart dimension fields.
Ok, but what is the expected result, specifically asking for the Stdev column 'that should vary accordingly'?
Also, is the attached data really the source, raw data table you are using? It seems you exported already your chart table with the two expressions from your OP. But then there is (at least) one dimension missing? Is this the field costinpatient? And you want to consider an overall, total Mean, but a Stdev that's calculated only across second dimension?
Please could you elaborate a bit more about your setting and requirements?
Overall, it's you that want help from us, not the other way around.
I think Johnamos needs 'Deviation from the Mean' and not Standard Deviation
=fabs(MeanExpression - (sum(costinpatient)/count(Distinct memnbr)))
where MeanExpression should be the expression for Mean as suggested by Stefan (=Avg( TOTAL ( sum(costinpatient)/count(Distinct memnbr) , YourChartDims )))