Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
for average use below expression
SUM(CRE_PAID_AMOUNT)/COUNT(DISTINCT PAID_MONTH)
Provide sample data or sample app...
APPLICATION ATTACHED HEREWITH PLS !
for average use below expression
SUM(CRE_PAID_AMOUNT)/COUNT(DISTINCT PAID_MONTH)
thanks a lot