Pivot Table Problem

[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

[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 |:>)

"jimicl" wrote:

>
> 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
>
>