# 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.

## Files

• Attached is your test file

Hope this will help

P:S. ... and even Nourish the Brain...

## Files

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

• 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 ().

• PERFECT!

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

I see this.

Thanks again!

• 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, and sorry for the late reply, lets's try subgroups.

• 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

• Attached is an example of what "grouping" actually means ...

## Files

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!