Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Boolean pivot table field

  1. #1
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,940
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello all,

    I have a pivot table linked to an Access database. One of the pivot fields is based on a Yes/No (True/False) field in the database. The problem is, when it comes across to the pivot table it's shown as 0 or 1. Now, some of the users are getting confused (understandably) in trying to work out what they want. Does anyone know how I can convert this to a Yes/No without changing the field in my Access database?

    I've tried formatting the number of the field with this:-

    No;-;Yes

    but I'm getting an error.

    Any ideas greatly appreciated,

    Dan

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Format as...

    [=0]"FALSE";"TRUE"

    Or...

    [=0]"No";"Yes"




  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,940
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Cheers Mark, that did the trick. I had a funny feeling you'd be the one to reply.

    Thanks again,

    Dan.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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