Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    need to change 0 or 1 to show as an empty check box or checked checked box

    this is too be done within a pivot table ... or can it be done in the data.

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    r3x3,

    Could you be a little more specific? Post an example?
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts
    The data for personida to personidx ais either 0 0r 1, with zero meaning no and 1 meaning yes row variable is the keynames01 to keynames 50. So a pivot tale, keys number by person id gives a 0 or 1 but I would rather report a uncheck check box or a checked box instead of 0 and 1.

    person1 person2 person3
    key 1 0 0 0
    key 2 1 0 1
    key 3 0 1 1
    Last edited by r3x3; 2013-08-17 at 20:57.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I think using checkboxes in the data and/or the pivot table would be cumbersome to create and maintain. In the data you would have to insert a checkbox for each datarow and link it to the appropriate cell (and would feed true/false, not 1/0, though that should not matter). When any new data would be added, additional checkboxes would have to be added.

    Whether or not you use checkboxes in the data, the pivot would just read the true/false and not do anything with the checkboxes, so a VBA routine would have to be created to run whenever the pivot was updated to remove any old checkboxes within the pivot table and create new ones linked to the appropriate cells.

    It would be helpful if you want to proceed with the VBA to post an example workbook with the pivot table created for us to work with. Note that the checkboxes would be custom so if the pivottable is modified, it may require modification of the code, so some of the utility of moving fields around to examine data in a pivot becomes less useful.

    Steve

  5. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi

    Perhaps you could use formulas to fetch and display the pivot results in an alternative format.
    (You could hide the actual pivot block and just show the 'alternative' display).
    see attached example file

    zeddy
    Attached Files Attached Files

  6. The Following User Says Thank You to zeddy For This Useful Post:

    r3x3 (2013-08-18)

  7. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Zeddy,
    Good Idea! That seems a much easier compromise than actually using the checkboxes created.

    Steve

  8. The Following User Says Thank You to sdckapr For This Useful Post:

    r3x3 (2013-08-18)

  9. #7
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts
    I came up with the same solution but I used o and Winding characters. Why can't managers understand 0 an 1.
    Last edited by r3x3; 2013-08-18 at 15:54.

  10. #8
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    ..because there are only 10 kinds of persons who understand binary.

    zeddy

Posting Permissions

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