+ Reply to Thread
Results 1 to 7 of 7

Count below #*Column in Pivot Table

  1. #1
    Registered User
    Join Date
    03-15-2015
    Location
    Espaņa
    MS-Off Ver
    2013
    Posts
    80

    Count below #*Column in Pivot Table

    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?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,977

    Re: Count below #*Column in Pivot Table

    Maybe: Q3
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    03-15-2015
    Location
    Espaņa
    MS-Off Ver
    2013
    Posts
    80

    Re: Count below #*Column in Pivot Table

    This is outside the pivot table, right? Any chances of achieving it inside the dynamic table?

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,977

    Re: Count below #*Column in Pivot Table

    I didn't realise that's what you were asking. I wouldn't know how to do that. AFAIK, the stuff that's inside the Pivot Table comes from its analysis of a Data Table.

    You can create calculated fields but I don't know if they could do what you want.

  5. #5
    Registered User
    Join Date
    03-15-2015
    Location
    Espaņa
    MS-Off Ver
    2013
    Posts
    80

    Re: Count below #*Column in Pivot Table

    Yeah, the problem is the Filters and the number of columns that may drastically vary...

  6. #6
    Registered User
    Join Date
    03-15-2015
    Location
    Espaņa
    MS-Off Ver
    2013
    Posts
    80

    Re: Count below #*Column in Pivot Table

    Quote Originally Posted by TMS View Post
    Maybe: Q3
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Anyhow this formula doesn't seem to be working ;( Any alternative, @TMS ?

    Thanks for your time,

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,775

    Re: Count below #*Column in Pivot Table

    I have run across some discussion of using PowerPivot and the DISTINCTCOUNT function in a somewhat similar situation. Without access to the source data from which the screen shot of the Pivot Table in post #1 was made that is about the most that I can offer.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 09-21-2018, 03:12 PM
  2. Count of a column in Pivot table for a given row
    By dhasa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-18-2018, 12:23 AM
  3. Create Pivot table with different count on Value column
    By bsguna in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-09-2016, 10:03 PM
  4. Pivot Table Count Without Row/Column Stacking
    By MarkMcCann in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-17-2013, 10:40 AM
  5. Pivot Table row and column count
    By smithy88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-26-2012, 05:24 AM
  6. Replies: 12
    Last Post: 02-06-2012, 11:23 AM
  7. Replies: 1
    Last Post: 02-09-2010, 06:16 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1