1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table Sub Totals

Discussion in 'Ask an Excel Question' started by MAH, Jul 6, 2018.

  1. MAH

    MAH New Member

    Messages:
    24
    In my pivot table I have 8 rows I setup subtotals for all items listed in the pivot. However in the subtotal it only loads in the items description and does not load in the text from the other rows. How can I get the other text to load into the subtotal?

    Attached Files:

  2. vletm

    vletm Excel Ninja

    Messages:
    4,043
    MAH
    Where is Your pivot table?
    I found four rows and eight columns from Sheet1.
  3. MAH

    MAH New Member

    Messages:
    24
    Sorry reloaded the file

    Attached Files:

  4. vletm

    vletm Excel Ninja

    Messages:
    4,043
    MAH
    Would one of those be something that You've looking for?

    Attached Files:

    Thomas Kuriakose likes this.
  5. MAH

    MAH New Member

    Messages:
    24
    The second lot that you have listed is what I am after. How did you do that?
  6. vletm

    vletm Excel Ninja

    Messages:
    4,043
    1) Select Pivot-table
    2) Select Layout
    3) Select suitable layout
    Screen Shot 2018-07-09 at 09.29.12.png
  7. MAH

    MAH New Member

    Messages:
    24
    Thank you

Share This Page