Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002:How to remove sub total rows in Pivot Table ?
Dear Sir,
Lets consider at the following Pivot Table. Sum of Amount AH Code AH NAME Total PKHLA009 ABLE GOOD 222 PKHLA009 Total 222 PKHLA491 UAMA LOGISTICS 250 PKHLA491 Total 250 PKHLB003 BEYOND HORIZON 500 PKHLB003 Total 500 PKHLB390 UNITED FREIGHT 750 PKHLB390 Total 750 As I add AH Name to the row field , the AH Code Sub total appear in the Pivot Table automatically. May I know how to remove the sub total without removing the AH Name ? Alternatively, is there a way not to show the sub total as I add the AH Name field Currently I use delete row to remove it, Is there any other better ways of doing this ? Thanks Low -- A36B58K641 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002:How to remove sub total rows in Pivot Table ?
Right click on sub total cell within pivit and select Hide option and it will
go off -- Regards Sri "Mr. Low" wrote: Dear Sir, Lets consider at the following Pivot Table. Sum of Amount AH Code AH NAME Total PKHLA009 ABLE GOOD 222 PKHLA009 Total 222 PKHLA491 UAMA LOGISTICS 250 PKHLA491 Total 250 PKHLB003 BEYOND HORIZON 500 PKHLB003 Total 500 PKHLB390 UNITED FREIGHT 750 PKHLB390 Total 750 As I add AH Name to the row field , the AH Code Sub total appear in the Pivot Table automatically. May I know how to remove the sub total without removing the AH Name ? Alternatively, is there a way not to show the sub total as I add the AH Name field Currently I use delete row to remove it, Is there any other better ways of doing this ? Thanks Low -- A36B58K641 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002:How to remove sub total rows in Pivot Table ?
Hello Sri,
Thanks for your tips. It works well. Low -- A36B58K641 "Sri" wrote: Right click on sub total cell within pivit and select Hide option and it will go off -- Regards Sri "Mr. Low" wrote: Dear Sir, Lets consider at the following Pivot Table. Sum of Amount AH Code AH NAME Total PKHLA009 ABLE GOOD 222 PKHLA009 Total 222 PKHLA491 UAMA LOGISTICS 250 PKHLA491 Total 250 PKHLB003 BEYOND HORIZON 500 PKHLB003 Total 500 PKHLB390 UNITED FREIGHT 750 PKHLB390 Total 750 As I add AH Name to the row field , the AH Code Sub total appear in the Pivot Table automatically. May I know how to remove the sub total without removing the AH Name ? Alternatively, is there a way not to show the sub total as I add the AH Name field Currently I use delete row to remove it, Is there any other better ways of doing this ? Thanks Low -- A36B58K641 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 : How to conditional format the Sub Total Table ? | Excel Discussion (Misc queries) | |||
How do I sort a Piviot table by the Total field in Excel 2002 | Charts and Charting in Excel | |||
Pivot Table Grand Total for Rows not functioning | Excel Discussion (Misc queries) | |||
Pivot Table - Grand Total for Rows | Excel Discussion (Misc queries) | |||
Pivot Table in Excel 2002 | Excel Discussion (Misc queries) |