Average Calculation

[upaliwije]

Hi Friends

In my QV document I have created following pivot table

PERIOD	2012	2013	2014	2015
MAY-JUN-JUL	17,954,582	18,362,554	24,091,463	16,047,949
OTHER- 9 MONTHS	68,782,229	49,225,098	67,029,590	50,529,104
TOTAL	86,736,810	67,587,652	91,121,053	66,577,052

I want to calculate month average of above figures depending on number of month  as per example given below

PERIOD	2012	Average
MAY-JUN-JUL	17,954,582	5,984,861	(17954582/3)
OTHER- 9 MONTHS	68,782,229	7,642,470	(68782229/9)
TOTAL	86,736,810	7,228,068	(86736810/12)

Could you please help me do it in another column of Pivot table itself

[MK_QSL]

Provide sample data or sample app...

[upaliwije]

APPLICATION ATTACHED HEREWITH PLS !

[MK_QSL · Accepted solution]

for average use below expression

SUM(CRE_PAID_AMOUNT)/COUNT(DISTINCT PAID_MONTH)

[upaliwije]

thanks a lot