Trouble with aggr function

[Anonymous]

I need to count the number of resources across various Proficiency levels. i.e Beginner, Intermediate No Knowledge, Advanced

If the 80* of the values marked for the resource is Beginner then he falls under beginner category or Advanced or Intermediate or no Knowledge

I need to display the total count of resources in a pivot table with 4 headings - Beginner,Intermediate No Knowledge, Advanced

I am attaching my file..Can somebody please help me with the expression.

I need to

[effinty2112 · Accepted solution]

Hi Sanjyot,

Is this what you want? Expression is :

Count(Name)/Count(TOTAL <Name> Name)

Kind regards

Andrew

Name	Proficiency	No Knowledge	Beginner	Intermediate	Advanced
Alfred Lui		84.62%	7.69%	6.15%	1.54%
Alok yadav		95.38%	1.54%	1.54%	1.54%
Anda X M ZHANG		80.00%	15.38%	4.62%	-
Andy Quintal		33.85%	35.38%	18.46%	12.31%
Andy Ray		50.77%	10.77%	20.00%	18.46%
Anjana Kumari Ashok Singh		98.46%	-	-	1.54%
Archer C Y WU		-	-	-	100.00%
Arunkumar Domakuntla		95.38%	-	1.54%	3.08%
Bruce J C Chen		-	3.08%	96.92%	-
Candice Yang		90.77%	9.23%	-	-
Cao Dongxue		78.46%	18.46%	3.08%	-
Cathy Y S WU		95.38%	4.62%	-	-
Chaney C N ZENG		96.92%	3.08%	-	-
Chaytali Suresh Gajarmal		95.38%	-	4.62%	-
Cindy X Zheng		38.46%	26.15%	15.38%	20.00%
Cloudy X Y Yu		47.69%	26.15%	16.92%	9.23%
David W Jia		38.46%	21.54%	26.15%	13.85%
Dennis Choi		46.15%	9.23%	24.62%	20.00%
derek		73.85%	15.38%	7.69%	3.08%
Deson D S WU		64.62%	10.77%	12.31%	12.31%
Divya Mulmule		75.38%	15.38%	6.15%	3.08%
Emily B J CUI		98.46%	-	1.54%	-
Erich Piña		90.77%	3.08%	6.15%	-
Erwin Joshua Palani		80.00%	20.00%	-	-
Gayatri PATIL		55.38%	16.92%	23.08%	4.62%
Guo Hua Chen		36.92%	15.38%	32.31%	15.38%
Harlan Z ZHU		33.85%	61.54%	3.08%	1.54%
Hrishikesh Yadav		73.85%	9.23%	7.69%	9.23%
Ip Man To		63.08%	33.85%	3.08%	-
Ivan Yip		35.38%	1.54%	15.38%	47.69%
JAY SHANKAR PANDEY		30.77%	24.62%	36.92%	7.69%
Jayden		60.00%	23.08%	16.92%	-
Jennie Z N ZHOU		41.54%	13.85%	44.62%	-
Jerry S H Yao		29.23%	26.15%	30.77%	13.85%
Jimmy H H WU		55.38%	10.00%	17.69%	16.92%
KAPIL BHAMRI		15.38%	47.69%	33.85%	3.08%
Kelvin Jia Hui Liang		61.54%	18.46%	20.00%	-
Kevin Kwan		70.77%	9.23%	18.46%	1.54%
Kiran Wani		78.46%	1.54%	15.38%	4.62%
Kit Lin		86.15%	10.77%	3.08%	-
Lokesh Singh Rathore		75.38%	1.54%	18.46%	4.62%
lyon Y Z LV		92.31%	6.15%	1.54%	-
Mandar Rane		64.62%	3.08%	20.00%	12.31%
Manuel alejandro Vazquez Donjuan		52.31%	16.92%	29.23%	1.54%
Mike W P XIAO		55.38%	16.92%	16.92%	10.77%
Monika Deshmukh		86.15%	12.31%	1.54%	-
Mukta M Mulay		81.54%	10.77%	6.92%	0.77%
Neil Hayward		78.46%	9.23%	4.62%	7.69%
Neo Jinhui LUO		49.23%	4.62%	40.00%	6.15%
Nick Y B LIU		46.15%	24.62%	29.23%	-
Nicko J H Guo		98.46%	1.54%	-	-
Nigel Brown		73.85%	4.62%	7.69%	13.85%
Nishant Kumar		78.46%	12.31%	4.62%	4.62%
Nissy Moncey		83.08%	15.38%	1.54%	-
Parimal		81.54%	-	12.31%	6.15%
Payal VIVEK NIGHOJKAR		93.85%	6.15%	-	-
Pete Mills		80.00%	6.15%	7.69%	6.15%
prabhjot		81.54%	9.23%	9.23%	-
Queenie K Y CHAN		66.15%	32.31%	-	1.54%
Rohit Anant Deshpande		78.46%	9.23%	12.31%	-
Rucha KHARE		53.85%	10.77%	24.62%	10.77%
sabeeha shaik		76.92%	15.38%	7.69%	-
sagar hanumandas biyani		90.77%	-	7.69%	1.54%
Saloni Raj		89.23%	7.69%	1.54%	1.54%
Sam Walton		64.62%	10.77%	12.31%	12.31%
Samuel Z M ZHAO		38.46%	18.46%	18.46%	24.62%
Sanjyot Salgar Patkar		95.38%	3.08%	1.54%	-
Sanket Harishchandra NEMADE		76.92%	9.23%	13.85%	-
Santosh Kumar D U V		93.85%	6.15%	-	-
Shetesh Dutta		40.00%	24.62%	12.31%	23.08%
Simon M S CHONG		-	32.31%	35.38%	32.31%
Sudhir R Kale		40.00%	16.92%	26.15%	16.92%
Sukesh Nadh		60.00%	20.00%	15.38%	4.62%
Sureshkumar		29.23%	24.62%	16.92%	29.23%
Swapnil Sahu		70.77%	16.92%	12.31%	-
Syeda Zoya Ali		98.46%	-	-	1.54%
Sze Chung NGAN		55.38%	18.46%	21.54%	4.62%
Thomas W C LEUNG		55.38%	18.46%	26.15%	-
Tom Z P TAN		60.00%	21.54%	15.38%	3.08%
Urmila Jayaparkah Jadhav		80.00%	9.23%	9.23%	1.54%
Vagdevi B		61.54%	16.92%	13.85%	7.69%
Vaishali Malhotra		87.69%	4.62%	6.15%	1.54%
Varsha Jain		83.08%	12.31%	4.62%	-
Veeramani ALLADA		90.77%	-	6.15%	3.08%
Vegiraju Sushmitha		98.46%	-	-	1.54%
Venkatesh K		75.38%	7.69%	12.31%	4.62%
Vickie Q YI/HSDC/ABC		75.38%	15.38%	7.69%	1.54%
Victoria Alesker		53.85%	9.23%	16.92%	20.00%
Vikash kumar		90.77%	1.54%	7.69%	-
Wing H Y He		18.46%	30.77%	50.77%	-
Wing Y LIN		90.77%	7.69%	1.54%	-
Wingyee Y Y LIANG		12.31%	73.85%	13.85%	-
Yogesh Apte		55.38%	9.23%	12.31%	23.08%
Yuan Lydia Wang		96.92%	1.54%	1.54%	-
Yvette Y C HUANG		56.92%	27.69%	15.38%	-
zhenghu chen		89.23%	-	10.77%	-

[Anonymous]

Thanks it worked