Average in Pivot Table

[upaliwije]

Hi Friends

I have following pivot table in my QV document

	Range	< 10,000		10,001-25,000		Total
TYPE	MONTH	Nos	AMOUNT	Nos	AMOUNT	Nos	AMOUNT
A	Nov-2016	795	5,974,131	1,144	18,808,103	1,939	24,782,233
A	Dec-2016	772	5,853,671	1,201	20,144,018	1,973	25,997,689
A	Jan-2017	863	6,520,365	1,434	23,976,680	2,297	30,497,045
A	Total	2,430	18,348,167	3,759	62,928,800	6,189	81,276,967
	Average	810	6,116,056	1,253	20,976,267	2,063	27,092,322
B	Nov-2016	178	1,311,761	344	5,513,150	522	6,824,910
B	Dec-2016	179	1,283,190	281	4,603,125	460	5,886,315
B	Jan-2017	198	1,413,659	378	5,992,583	576	7,406,242
B	Total	554	4,008,610	996	16,108,857	1,550	20,117,467
	Average	185	1,336,203	332	5,369,619	517	6,705,822
C	Nov-2016	135	936,589	244	3,902,577	379	4,839,166
C	Dec-2016	129	845,520	211	3,370,800	340	4,216,320
C	Jan-2017	159	1,117,477	268	4,166,362	427	5,283,839
	Total	421	2,899,585	711	11,439,739	1,132	14,339,324
	Average	140	966,528	237	3,813,246	377	4,779,775
A	Total	1,108	8,222,480	1,732	28,223,829	2,840	36,446,309
B	Total	1,080	7,982,380	1,693	28,117,943	2,773	36,100,324
C	Total	1,220	9,051,501	2,080	34,135,625	3,300	43,187,126
	Total	3,408	25,256,362	5,505	90,477,397	8,913	115,733,759

I want to calculate the average and Grand Total of each type . In other words I want to show figures highlighted in red in my pivot table. Can You pls advise how to do it

[vinieme12]

See Attached Sample

[upaliwije]

Thanks for your help,

This is not exactly what I want !

[vinieme12]

Yes, i'm only showing you how you can achieve what you want...

Another way would be to add dummy dimension values and use Pick(Match( for your expressions