How to Calculate Standard Deviation

Tue, 08 Jan 2013 16:36:56 GMT

Hi all,

I am having a straight table with

Dimension as Group and Book

Expression is sum(Revenue)

I want to show a stddev value of Group by day

ex:stdev(aggr(sum(Revenue),Group, Day)

Another is:

stdev(aggr(sum(Revenue),Book,Day)

both value comes correct.

Work which has to be done is for stdev by book expression in partial sum i want to show the value of stddev of group.

Please suggest how to acchieve it.

ex:

Group Book stdev(aggr(sum(Rev),Group,Day) stddev(aggr(sum(Rev),Book,Day)

--------- ------- ------------------------------------------------ -----------------------------------------------

Grp1 A 5.9826 2.399

B 2.111

Total 5.9826 2.122

---------------------- -----------------------------------------------

Grp2 D 2.8969 3.22

E 4.22

Total 2.8969 3.11

So where the Total is 2.122 for group1 i want 5.9826 but above 2 values as(2.399 & 2.111) should remain in same position.

same for group 2.

Please anyone can you suggest me a way how to procced

Thanks & Regards,

Pranav

Re: How to Calculate Standard Deviation

Tue, 08 Jan 2013 17:17:46 GMT

Hi Pranav,

If you are using a Pivot Table the dimentionality function might help you, so the expression should be:

if( dimensionality ( ) = 1, stdev(aggr(sum(Rev),Group,Day) , stddev(aggr(sum(Rev),Book,Day) )

Hope this helps

Regards!

Fri, 11 Jan 2013 13:37:04 GMT

Thanks Gabriela,

Its working awsome thanks a lot.

Regards,

Pranav