Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table Problem
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 |
#2
|
|||
|
|||
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 DataFilterAutoFilter. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I am having trouble keeping numbers formatted in a Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Pivot Table Problem | Excel Worksheet Functions |