Results 1 to 4 of 4

Thread: Pivot Table Filter

  1. #1

    Pivot Table Filter



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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:

    Click image for larger version. 

Name:	Imagem1.png 
Views:	19 
Size:	29.7 KB 
ID:	7729

    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.

  2. #2
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,675
    Articles
    0
    Excel Version
    2010 on Xubuntu
    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
    Thank you Ken for this secure forum.

  3. #3
    .................!

    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!



    Thanks anyway

  4. #4
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,675
    Articles
    0
    Excel Version
    2010 on Xubuntu
    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 :-)
    Thank you Ken for this secure forum.

Tags for this Thread

Posting Permissions

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