Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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% | - |
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% | - |
Thanks it worked