Pivot Table Problem

J

jimicl

hi friends, so much time uh... I've got the next PIVOT TABLE:


CODE NAME DEBITBALANCE

0M EMILE MUSLEH SALEH 20,001
0O SOC. IND. ICASUS LTDA 660,200
1A ADT SECURITY -
1B HOTELERA OCEANIC LTDA -
1C YOUSEF COMERCIAL LTDA -



Is there a way to show just the data values :

CODE NAME DEBITBALANCE

0M EMILE MUSLEH SALEH 20,001
0O SOC. IND. ICASUS LTDA 660,200


NOTE: The other ones are in "0" or "-" value, because in the data base
are 2 values subtracted.

Ex: DEBIT BALACE= NUM1-NUM2


data base:


CODE NAME NUM1
NUM2 DEBITBALANCE
0K JOSE CAMARENA Y CIA LTDA 50,000 50,000 0


thank u i hope u can make it..

BYE
JIMICL
 
C

CyberTaz

Hello-

Why would you want to use a Pivot Table for this? How about AutoFilter?

Make any cell in your Data Range the active cell, then go to
Data>Filter>AutoFilter. Next, click the button for the DebitBalance, select
Custom & set the following dialog box for 'Greater than' 0. You can hide the
Num1 & Num2 columns if you wish.

Assuming you need to do this with some degree of regularity, you can make a
macro or use a Custom View to automate the process.

HTH |:>)
 
Top