+ Reply to Thread
Results 1 to 6 of 6

Pivot table + added columns - HOW TO FILTER ALL

  1. #1
    Registered User
    Join Date
    04-07-2020
    Location
    Quebec
    MS-Off Ver
    Window 10 Pro - Excel 2016
    Posts
    19

    Pivot table + added columns - HOW TO FILTER ALL

    Hi!

    I created a pivot table and had to manually add columns to calculate growth%. How do I get both the PIVOT TABLE and the added columns to filter together?

    eg. column A-D is pivot data then F & H are my added columns with formulas.

    Thanks!
    Last edited by Scizzy; 04-22-2020 at 11:31 AM.

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    10,965

    Re: Pivot table + added columns - HOW TO FILTER ALL

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

  3. #3
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    10,965

    Re: Pivot table + added columns - HOW TO FILTER ALL

    Administrative note
    Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
    Thanks

  4. #4
    Registered User
    Join Date
    04-07-2020
    Location
    Quebec
    MS-Off Ver
    Window 10 Pro - Excel 2016
    Posts
    19

    Re: Pivot table + added columns - HOW TO FILTER ALL

    Done I think

  5. #5
    Registered User
    Join Date
    04-07-2020
    Location
    Quebec
    MS-Off Ver
    Window 10 Pro - Excel 2016
    Posts
    19

    Re: Pivot table + added columns - HOW TO FILTER ALL

    Tried but no matter how much I reduce it keeps failing on upload. I can't make it 1000KB

  6. #6
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    10,965

    Re: Pivot table + added columns - HOW TO FILTER ALL

    You can also zip the file if needed

+ 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. Filter for Columns of Data in Pivot Table
    By chadom in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-10-2017, 04:13 PM
  2. [SOLVED] VBA filter columns of pivot table.
    By countryfan_nt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-02-2017, 07:20 AM
  3. Replies: 9
    Last Post: 03-18-2015, 07:16 AM
  4. Pivot table not showing the selected items when filter added
    By ShaliniGomes in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-23-2014, 01:44 AM
  5. Pivot Table filter with added fields?
    By rbpd5015 in forum Excel General
    Replies: 3
    Last Post: 08-17-2010, 02:10 PM
  6. Replies: 2
    Last Post: 11-03-2009, 03:30 PM
  7. [SOLVED] Added new columns - Pivot Table not refreshing - why?
    By Joan Sims in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-11-2006, 08:35 PM

Tags for this Thread

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