Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Average Calculation

Hi Friends

In my QV document I have created following pivot table

PERIOD2012201320142015
MAY-JUN-JUL17,954,58218,362,55424,091,46316,047,949
OTHER- 9 MONTHS68,782,22949,225,09867,029,59050,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

PERIOD2012Average
MAY-JUN-JUL17,954,5825,984,861(17954582/3)
OTHER- 9 MONTHS68,782,2297,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

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

for average use below expression

SUM(CRE_PAID_AMOUNT)/COUNT(DISTINCT PAID_MONTH)

View solution in original post

4 Replies
MK_QSL
MVP
MVP

Provide sample data or sample app...

upaliwije
Creator II
Creator II
Author

APPLICATION ATTACHED HEREWITH PLS !

MK_QSL
MVP
MVP

for average use below expression

SUM(CRE_PAID_AMOUNT)/COUNT(DISTINCT PAID_MONTH)

upaliwije
Creator II
Creator II
Author

thanks a lot