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


--
jimicl
------------------------------------------------------------------------
jimicl's Profile: http://www.excelforum.com/member.php...fo&userid=3442
View this thread: http://www.excelforum.com/showthread...hreadid=466283