+ Reply to Thread
Results 1 to 9 of 9

Outline Same Text

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,952

    Outline Same Text

    My boss wants a highly formatted report, and I'm trying to do it in a pivot table. But one area is giving me trouble, so I'm asking for help. In the table attached, in the "Acct Descr" column, I'd like to outline unique items (see the "How I'd like it" tab if my description falls short). I wasn't sure if there was a Pivot function that would do it, or if I needed to achieve it through Conditional Formatting. I started going down that road by couldn't figure out the formula to use. Any help would be highly appreciated.
    Attached Images Attached Images
    Attached Files Attached Files
    I know I'm not stupid, but I suspect I'm a lot stupider than I think I am

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,922

    Re: Outline Same Text

    It looks like you could just modify the pivot table style to add top and bottom borders to the Row Subheading3 section. You'll need to check the Row headers option on the Design tab.

  3. #3
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Outline Same Text

    The lack of included underlying data is making this PT difficult to change. Could you include a subsection of your data source?

    Pete

  4. #4
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,952

    Re: Outline Same Text

    Underlying Data added.
    Attached Files Attached Files

  5. #5
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,952

    Re: Outline Same Text

    Rorya,
    I'm not following your direction. If I check Row Headers on the Design tab it Bolds my columns A and B, making more issues.

  6. #6
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Outline Same Text

    John:

    Right click your PT.
    Pivot Table Options
    Display Tab
    Uncheck: Show expand/collapse buttons.

    Click OK.

    Pete

  7. #7
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,952

    Re: Outline Same Text

    Um, Pete, my issue has nothing to do with the Expand/Collapse buttons. did you look at the "How I want it" tab? That's what I'm trying to achieve, without doing it manually. I CAN do it through Conditional Formatting, but I'd like to see if there's a way to do using just the Pivot options.

  8. #8
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Outline Same Text

    Conditional formatting would be the way to go John.

  9. #9
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,952

    Re: Outline Same Text

    Then that's the way I'll do it. Thanks for clarifying there's no "better" way to do it. I've attached my example with the conditional formatting applied for anyone who'd like to see it.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA to Group Rows (outline) based on Text
    By IndieKiller in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2017, 09:48 AM
  2. [SOLVED] Indent text to extent of hierarchical outline level
    By snapfade in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-21-2013, 03:24 PM
  3. outline
    By Vinaya in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-22-2006, 03:10 PM
  4. Replies: 1
    Last Post: 12-26-2005, 02:40 PM
  5. [SOLVED] outline & groups
    By G Gustavo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-10-2005, 04:05 PM
  6. Outline.ShowLevels
    By rjamison in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2005, 08:05 PM
  7. Re: Outline.ShowLevels
    By rjamison in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2005, 08:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1