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.

    How do I add the additional values to 'Filtered Check-ins'? When I set this filter to TRUE, I see customers with 5 and 10 visits. What if I want to add additional visit values like 25, 50, 100, and so on?


    Thanks

    With more data ... just copy formula down ... it will update automatically :)


    and do not forget to Refresh your Pivot Table ...

    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 :)

    Edited once, last by Carim ().

    Thanks 1

    You are welcome :)


    Glad it could 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 :)

    Hmmm?


    =IF(OR(AL2=5,AL2=10,AL2=25,AL2=50,AL2=100),TRUE,FALSE)


    I am curious how I can edit this formula to be this:

    AL2=5 but is less that the next number 10 (including 6,7,8, and 9)

    AL2=10 but is less than the next number 25 (including 11 through 24)

    AL2 =25 but is less than the next number 50 (including 26 through 49)

    AL2 =50 but is less than the next number 100 (including 51 through 99)


    Thanks

    Hi,


    Not sure to fully understand ... since it seems to me your new rules will boil down to retaining records between 5 and 99 ...


    Another interpretation of your comment could be that you are after creating 4 sub-groups ....


    Please clarify

    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 :)

    Edited once, last by Carim ().

    Thanks 1
    Quote from PETRODATAjames

    Thanks, and sorry for the late reply, lets's try subgroups.

    Hi,


    Have the strange feeling your own idea about your final objective is, to say the least, not extremely clear ... ?(

    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