+ Reply to Thread
Results 1 to 6 of 6

Possibility to hide column in pivot table

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Possibility to hide column in pivot table

    Hi,

    I have 2 columns with gigabytes.

    One is the number and one is a text (with number + "GB" as text).
    I want to show only column with labels. And hide with numbers (i am using it only to sorting ascending).

    It is possible to hide column in pivot?

    Please help,
    Jacek

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Possibility to hide column in pivot table

    Why do you need two columns for that? Just format the number column to display GB at the end.
    Rory

  3. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: Possibility to hide column in pivot table

    Basically, if you stick to 2 colukmns concept - no.
    What is used for sort within a given pivot table has to be in this pivot. Of course you can hide a column in a worksheet or even prepare a macro to hide it every time pivot is recalculated (the same as you can use a macro to change formatting of data already in pivot), but data cannot be used as a sorting key if it is not a part of the pivot :-(
    Best Regards,

    Kaper

  4. #4
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Possibility to hide column in pivot table

    thank you Guys,

    rorya.
    How can i do this?

    Problem is that this are GB. And when i have 1024 GB i should have 1 TB.
    There is possibility to inout if statement?

    Best,
    Jacek

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Possibility to hide column in pivot table

    Not if you need to do an accurate conversion. Simple answer is just to hide the worksheet column.

  6. #6
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Possibility to hide column in pivot table

    thank you,

    best,
    Jacek

+ 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: 6
    Last Post: 01-24-2017, 06:56 PM
  2. Hide cell content but keep filter possibility...
    By johnny_w in forum Excel General
    Replies: 4
    Last Post: 07-02-2015, 11:48 AM
  3. [SOLVED] Macro to hide last column in a pivot table
    By Shellybelly in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2014, 07:01 AM
  4. Using Macros - info from sheet go into a Pivot Table - how Can I hide the Pivot Table?
    By traceylreed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2012, 09:54 AM
  5. hide/unhide a column when a pivot table in a new workbook is refreshed.
    By ronanm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2011, 03:24 PM
  6. way to hide the column, row and data field in a pivot table
    By Richard Flame in forum Excel General
    Replies: 0
    Last Post: 06-05-2007, 03:16 PM
  7. Pivot table - hide detail for column
    By kbear in forum Excel General
    Replies: 0
    Last Post: 03-22-2005, 04:06 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