+ Reply to Thread
Results 1 to 7 of 7

Filtering data in a pivot table by changing column labels?

  1. #1
    Registered User
    Join Date
    03-10-2012
    Location
    cosprings
    MS-Off Ver
    Excel 2010
    Posts
    5

    Filtering data in a pivot table by changing column labels?

    Ok on this file http://www.mediafire.com/?972vo91hn6yk621 you can see I have a lot of data I would like to trim this down. Is there any way I can make the column labels for example .2+or-10% so it will smash the data in a little tighter and I can delete some column labels?

    I know I can delete the columns that I dont need but I end up with very little data filling the cells/a lot of blanks +or-10% is fine for what I'm doing.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,108

    Re: Filtering data in a pivot table by changing column labels?

    Many of us are unable, or not allowed to visit websites like that to see your data. Could you upload a sample here please?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    03-10-2012
    Location
    cosprings
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Filtering data in a pivot table by changing column labels?

    It wont add on this site the file is probably to big.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,108

    Re: Filtering data in a pivot table by changing column labels?

    Can you create a sample file with dummy data in it? or reduce the amount of data?

  5. #5
    Forum Contributor
    Join Date
    02-22-2011
    Location
    Rhône Alpes, France
    MS-Off Ver
    Excel 2007
    Posts
    201

    Re: Filtering data in a pivot table by changing column labels?

    Hi,
    May be by grouping data in column
    See attached file with group column by 0.2
    Hope this helps
    Best regards
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    03-10-2012
    Location
    cosprings
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Filtering data in a pivot table by changing column labels?

    That is exactly what Im looking for thank you very much. How did you do that?
    Last edited by fuse; 03-18-2012 at 04:39 PM.

  7. #7
    Forum Contributor
    Join Date
    02-22-2011
    Location
    Rhône Alpes, France
    MS-Off Ver
    Excel 2007
    Posts
    201

    Re: Filtering data in a pivot table by changing column labels?

    Hi,
    Right click on one cell of the column label "Engine Load.."
    Then select "Group" and Group "By" : input your choice
    Best regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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