Hi Tiruvazhi,

Hope it helps.

http://my.opera.com/duncans/blog/including-a-variance-or-percentage-growth-or-change-between-two-group-members

http://www.simple-talk.com/sql/reporting-services/advanced-matrix-reporting-techniques/

Thanks Robert for the information.

But it didn't solve my problem.

I just want a simple formula to calculate variance in SSRS between monthly totals.

Please help.

thanks Tiruvazhi

The variance is computed as the average squared deviation of each number from its mean. For example, for the numbers(months) 1, 2, and 3, the mean is 2(2nd month) and μ is the mean(mid month val) and N is the number of months.

The formula (in summation notation) for the variance in a population is

 =(SQUARE(Month(Fields!DateValue.Value)-AVG(Month(Fields!DateValue.Value)))))/SUM(Month(Fields!DateValue.Value))

Robert:

I'm sorry for the confusion. It's NOT the variance as a function.

I just want to calculate the % difference between monthly totals. For example when compare to January total how much February total is variant....

please provide a formula for that ....thanks...

Formula :

Mean : Mean = Sum of X values / N(Number of values)

Standard Deviation :

Population Standard Deviation :

Variance : Variance = S*S

Here is the example: http://www.mathsisfun.com/data/standard-deviation.html