+ Reply to Thread
Results 1 to 6 of 6

Pivot table + added columns - HOW TO FILTER ALL

  1. 04-22-2020, 10:08 AM #1
    Scizzy
    Scizzy is offline
    Registered User
    Join Date
    04-07-2020
    Location
    Quebec
    MS-Off Ver
    Window 10 Pro - Excel 2016
    Posts
    20

    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.
    Reply With QuoteRegister To Reply
  2. 04-22-2020, 11:14 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,445

    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
    Reply With QuoteRegister To Reply
  3. 04-22-2020, 11:14 AM #3
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,445

    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
    Reply With QuoteRegister To Reply
  4. 04-22-2020, 11:31 AM #4
    Scizzy
    Scizzy is offline
    Registered User
    Join Date
    04-07-2020
    Location
    Quebec
    MS-Off Ver
    Window 10 Pro - Excel 2016
    Posts
    20

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

    Done I think
    Reply With QuoteRegister To Reply
  5. 04-22-2020, 11:32 AM #5
    Scizzy
    Scizzy is offline
    Registered User
    Join Date
    04-07-2020
    Location
    Quebec
    MS-Off Ver
    Window 10 Pro - Excel 2016
    Posts
    20

    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
    Reply With QuoteRegister To Reply
  6. 04-22-2020, 11:33 AM #6
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,445

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

    You can also zip the file if needed
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. How to get average of grand total in pivot table, without added extra columns
    By Akram147 in forum Excel General
    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. how to update pivot table when new rows/columns are added to the original data?
    By mingali in forum Excel General
    Replies: 2
    Last Post: 11-03-2009, 03:30 PM
  7. 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1