Pivot Table questions and a new field to add

    • New

    This Tiered Instructor Payroll (w_ No Shows + Late Cancels) UPDATED (Training Mate) je3v2.xlsm has a tab named 'Instructor Summary'. This tab has a couple of PivotTables on it. Where is the PivotTable Field menu? When I create a PivotTable this menu is displayed on the right. I would like to add the number of classes that the instructor taught. This can just be a count of his name, I think. This class count can be added to column 'C' on the same row as their name.


    Thanks

    • New

    Hi,


    If your Pivot Table menu has disappeared, just right-click on any of the cells in your Pivot table and click on the ‘Show Field List’ option


    Hope this will help :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    • New

    Hi,


    Have you managed to fix your problem ...?

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    • New

    Hi,


    Is your new thread :

    Post
    Pivot Table with a filter that displays a SUM of Total with a specific number or numbers
    I have a worksheet that has a column 'AL' named Total Check-ins - All Time. I would like my PivotTable to list the customer's name and then a column that show me the Sum of Total Check-Ins - All Time, but only if the number is 5, 10, 25, 50, 100, maybe more, but those fixed numbers only.
    I cannot find how this can be done.
    PETRODATAjames

    a continuation of this problem ...?

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login