+ Reply to Thread
Results 1 to 2 of 2

Filtering small values out from Pivot

  1. #1
    Registered User
    Join Date
    03-27-2017
    Location
    Finland
    MS-Off Ver
    2013
    Posts
    4

    Filtering small values out from Pivot

    Hi,

    I have a Pivot table where on Rows I have products and on Column Country. I would like to filter out some of the smallest values.
    Is this possible filter out everything that is below 20pc for example.

    US MX FR DE
    Prod 1 100 50 100 15
    Prod 2 500 2 100 500
    Prod 3 1 500 100 500

    Thanks!

    -Kane-

  2. #2
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Filtering small values out from Pivot

    Hi,

    you could create an helper column on source data

    =C2>20


    and filter TRUE

    Regards
    Attached Files Attached Files
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

+ 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. [SOLVED] filtering a pivot chart / pivot table on x-axis values
    By Trebor777 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-20-2016, 01:28 PM
  2. Filtering differnt Fields in Pivot table based on different values
    By brennaa1 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-20-2013, 04:37 PM
  3. filtering axis values on a pivot chart
    By jrosko1 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-25-2013, 02:53 PM
  4. Filtering By Values In Pivot Table (pic included)
    By no.18shirt in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-11-2013, 06:02 PM
  5. Filtering By Values In Pivot Table (pic included)
    By no.18shirt in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-11-2013, 04:56 PM
  6. Filtering values in a pivot table
    By vsm in forum Excel General
    Replies: 3
    Last Post: 11-16-2011, 11:41 PM
  7. Replies: 0
    Last Post: 10-14-2009, 03:27 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