Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts

    exclude zero in pivot table

    hi,

    i have the down pivot data sample and i want to exclude the zero values
    DELTA (x-y) DELTA (x-y) Total
    fax 1999 2000 2001
    akrm 0 0 0 0
    adm 0 0 0 0


    an ideas...
    Last edited by dubdub; 2013-10-02 at 01:38.
    TIA
    dubdub

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Not sure of your setup, but autofilter could hide the zero values.

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts
    You could try going to the actual data that the PT is based on and create a new column. Call the new column somehting like ZERO. Put a formula in the new Column that identifies when data is zero and returns a value. BY Example if each row in the Data has 11 columns of crieteria some which could be zero, expand the Data to include a new Col 12. Then use a formula such as IF(AND(A10 =0, B10 = 0, C10 = 0),25,0) Copy down.
    Run the PT and include the new column as part of the PT. Using above example, after the PT is done filter on the new column to exclude all 25's. Now your zero's are filtered out of the PT.

    Hope this helps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •