

Creator II
2016-02-06
11:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Average Calculation
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
410 Views
1 Solution
Accepted Solutions

MVP
2016-02-07
03:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
for average use below expression
SUM(CRE_PAID_AMOUNT)/COUNT(DISTINCT PAID_MONTH)
323 Views
4 Replies

MVP
2016-02-07
03:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Provide sample data or sample app...
323 Views


Creator II
2016-02-07
03:35 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
APPLICATION ATTACHED HEREWITH PLS !
323 Views

MVP
2016-02-07
03:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
for average use below expression
SUM(CRE_PAID_AMOUNT)/COUNT(DISTINCT PAID_MONTH)
324 Views


Creator II
2016-02-07
03:54 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thanks a lot
323 Views
