+ Reply to Thread
Results 1 to 4 of 4

Reducing Pivot Table Columns

  1. #1
    Registered User
    Join Date
    03-21-2020
    Location
    İstanbul, Turkey
    MS-Off Ver
    2016
    Posts
    18

    Reducing Pivot Table Columns

    Hi,

    There are 5 title in my pivot table columns; "Material", "Montage", "Disassembly", "Reassembly" and "Common"

    I want to remove "Common" area but it's values must seem both "Disassembly" and "Reassembly" areas. How can I solve it?

    Thanks...

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    371

    Re: Reducing Pivot Table Columns

    you could help yourself and others trying to assist you in uploading your spreadsheet AND show what you believe your solution would look like (part of the Forum Rules too).... That being said, i can only guess at what it is that you mean...perhaps you could FILTER your data and delete the unNeeded items? Other than that, no clue as to what you mean.

  3. #3
    Registered User
    Join Date
    03-21-2020
    Location
    İstanbul, Turkey
    MS-Off Ver
    2016
    Posts
    18

    Re: Reducing Pivot Table Columns

    Ok, ı upload file.
    In Pivot table, there is "COMMON" columns.
    Values of "COMMON" ​​should appear in both "Reassembly" and "Disassembly" even if "COMMON" columns is removed or filtered.
    How can ı solve it with formula, macro and another way?
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    371

    Re: Reducing Pivot Table Columns

    On your Pivot Table where it says "Column Labels" click on the downward pointing triangle, this will show you what is called a Filter. Unselect 'Common' by clicking where the check mark (aka Tic mark) is and it acts as a toggle....click it once and it will unselect Common....click again and it will select Common. This is how you can filter the data to show or NOT show certain data.

+ 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: 2
    Last Post: 09-13-2017, 01:55 AM
  2. Replies: 7
    Last Post: 02-27-2017, 07:41 AM
  3. [SOLVED] Reducing columns in scroll
    By wacky_diva in forum Excel General
    Replies: 4
    Last Post: 10-17-2012, 03:07 PM
  4. [SOLVED] Multiple Columns in Pivot Table (but don't show in Pivot Chart)
    By Gideon1973 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-23-2012, 10:57 AM
  5. Reducing Rows & Columns
    By Attila in forum Excel - New Users/Basics
    Replies: 50
    Last Post: 05-16-2008, 01:04 PM
  6. [SOLVED] Reducing the size of an xls file with pivot charts
    By Valeria in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-19-2005, 09:06 AM
  7. [SOLVED] Reducing Pivot Table file sizes?
    By rgfdahgear in forum Excel General
    Replies: 0
    Last Post: 02-04-2005, 05: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