+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Layout Issues

  1. #1
    Registered User
    Join Date
    03-31-2021
    Location
    As, Belgium
    MS-Off Ver
    O365
    Posts
    6

    Pivot Table Layout Issues

    Hello,

    I have some questions about the layout(format) of a pivot table.
    i hope that someone can help me with this issues and/or can tell me where i can find a good tutorial about the layout of a pivot table.

    -Sometimes you get as title(subtitle) of a pivot table "Sum Of (field which is used in values). When you post more values or maybe also in other cases you don't get this title,
    is it possible to add this title manually in one or other way. Maybe in an option menu.
    -Sometimes it is not possible to add a filter to a column of a pivot table. Can someone tell me what the reason can be of this feature
    -In one Pivot Table I can add the filter to line of the column names, but i can add them the blank row above the row with column names. Can anyone explain the reason of this feature and how i can resolve this.
    -In several pivot tables, i get Row Names or Row Label as name of my first column Header, the other fieldnames of the columns are the names of the attributes that i selected in my Pivot Table as row. Can anyone explain the reason of this feature and how i can resolve this.

    Thank You In Advance

    My Best Regards

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,548

    Re: Pivot Table Layout Issues

    -In several pivot tables, i get Row Names or Row Label as name of my first column Header, the other fieldnames of the columns are the names of the attributes that i selected in my Pivot Table as row. Can anyone explain the reason of this feature and how i can resolve this.
    When you select either Outline or Tabular form as the report layout then you should get the fieldname as the header of the first column.
    When you select Compact form then you get Row Labels as the header.
    As to the rest I would suggest that upload an .xlsx file, using the instructions in the banner at the top of the page, which illustrates each of the three issues.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Replies: 5
    Last Post: 03-08-2018, 08:14 AM
  2. [SOLVED] Pivot table-remove expand and close from pivot layout
    By excelmr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-01-2015, 07:00 PM
  3. Pivot Table Layout
    By frustrated in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-06-2015, 02:40 PM
  4. Layout of pivot table
    By gak67 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-22-2015, 09:40 PM
  5. Pivot Table layout
    By leo73pk in forum Excel General
    Replies: 2
    Last Post: 12-21-2010, 12:29 AM
  6. pivot table layout
    By indieman in forum Excel General
    Replies: 4
    Last Post: 03-11-2010, 04:57 AM
  7. Pivot Table Layout
    By smlaff01 in forum Excel General
    Replies: 4
    Last Post: 11-01-2007, 09:06 AM

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