Pivot Table Filter

Hi Forum People!
I'm having a "problem" on a pivot table filter field.
It happens that I've made a fool out of myself because of this...
I have a column which has a filter that goes from 15 to 18 but when you go down the filter list this is what you get:



Why is it repeating the values in that order?
The formatting is the same (number), the formula is the same...

This is really jeopardizing the report's validity!

Thanks in advance for your help.

Hi and welcome
please post a sample sheet ( click Go advanced - Manage attachments).
Without seeing the source data and how you have grouped it is difficult to help
Thanks

:loco: .................!

As I was preparing the file to upload, i found out that, even formatting all columns as number, there were some as text....!
When I got the error for the first time, i reviewed all fields formatting. I can now see that it didn't work!

:eyebrows::eyebrows:

Thanks anyway

Glad you solved your problem and let us know.
Formatting has nothing to do with the underlying value, it(s only the way XL presents it to you
To avoid this kind of error, do not use manual cell alignment. Then one sees the difference between text ( left aligned) and numbers ( right aligned), saving time and effort