Hello,
I have the following table structure.
Average of Nota Final Column Labels Artes1003 CienciasPoliticas1003 Convivencia1003 Espaņol1003 Estadistica1003 Etica1003 Filosofia1003 Fisica1003 Informatica1003 Ingles1003 Quimica1003 Religion1003 Sociales1003 Trigonometria1003 Grand Total Primer Periodo Primer Periodo Primer Periodo Primer Periodo Primer Periodo Primer Periodo Primer Periodo Primer Periodo Primer Periodo Primer Periodo Primer Periodo Primer Periodo Primer Periodo Primer Periodo Row Labels Grado 1003 Grado 1003 Grado 1003 Grado 1003 Grado 1003 Grado 1003 Grado 1003 Grado 1003 Grado 1003 Grado 1003 Grado 1003 Grado 1003 Grado 1003 Grado 1003 Alvares Leon Gabriela 3.38 3.59 3.90 3.38 3.81 4.43 3.38 4.00 3.68 2.19 3.03 3.45 3.68 2.87 3.48 Aponte Aldana Johan Fred 3.65 2.63 3.80 3.33 2.65 4.50 2.53 3.48 3.83 2.56 2.64 3.38 2.38 2.84 3.15 Ballen Acosta Luz Amparo 2.50 2.90 3.50 2.24 2.07 4.28 2.63 3.25 1.98 2.13 2.88 2.49 0.00 3.22 2.57 Castaņeda Camargo Luisa Fernanda 3.48 3.09 3.60 3.34 4.57 4.43 2.94 4.23 3.53 3.28 3.03 3.93 3.35 3.33 3.58 Castellanos Carrillo Paula Andrea 3.63 3.08 3.60 3.48 3.81 4.43 3.00 4.00 3.30 3.41 3.48 3.80 2.38 0.00 3.24 Diaz Beltran Karol Daniela 3.48 3.30 3.70 3.78 4.60 4.45 3.70 4.10 3.45 4.56 3.32 3.40 3.14 4.21 3.80 Gaitan Sanchez Anyi 4.15 3.90 3.90 3.56 3.05 4.28 4.15 3.78 4.00 2.76 3.56 3.40 3.90 3.39 3.70 Gasca Cabrera Juan Diego 1.53 0.00 4.00 4.04 4.50 1.00 0.00 3.25 0.00 2.44 3.71 3.58 0.00 4.04 2.29 Gomez Alfonso Diego Armando 3.70 3.15 3.50 3.37 3.81 4.53 2.90 3.48 3.68 2.78 2.64 3.25 3.30 2.49 3.32 Gomez Garcia Paula Andrea 3.25 3.00 3.60 3.96 2.05 4.53 2.53 3.85 3.33 3.98 3.02 3.65 2.38 2.66 3.27 Guevara Cortes Lizeth Nathalya 3.93 3.75 3.90 3.45 3.81 4.28 3.38 4.18 3.60 3.05 3.41 3.75 3.30 3.72 3.68 Gutierrez Hidalgo Oriana Del Valle 4.50 4.05 3.80 4.00 4.57 4.43 4.24 3.85 4.18 3.47 3.78 3.83 3.83 3.95 4.03 Huertas Socadaguy Daniel Alejandro 3.53 2.93 3.90 3.30 3.85 4.75 3.43 3.63 3.48 2.78 3.56 3.53 4.05 3.70 3.60 Leon Ordoņez Yoni Esteban 1.13 2.50 3.80 1.88 2.36 4.43 2.13 3.65 1.98 2.30 2.72 3.32 2.63 2.64 2.67 Lopez Garcia Jerson Alfonso 0.00 3.50 1.58 3.55 4.65 0.00 3.25 2.33 3.28 3.10 2.83 3.50 4.06 2.74 Maldonado Monsalve Diana Carolina 4.04 0.00 4.00 3.44 3.30 4.43 0.00 3.10 0.00 0.00 3.80 0.00 0.00 2.01
As you can see, it has a final column called Grand Total.
This is a Pivot Table
I was wondering if just beside Grand Total I can add a new Column that counts all numbers below 3.5 in the row, and if found 3 matches, then the cell would simply display 3.
Is that possible? How can I achieve this?
Bookmarks