Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables
1) I have 2 fields in the Row section of the Pivot Table. Is there a way to
set it up so you don't have a total at the end of each value change in the first field of the row section? I dont want any subtotals totals; just the grand total. 2) Is there a way to tell the pivot table that on the columns not show the blank or empty columns? Thank you for your help, Steven |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables
To turn off the subtotals, right-click on the first Row field button.
Choose Field Settings. Under Subtotals, choose None, and click OK To hide columns, you can click the dropdown arrow on the column field button Remove the check mark from items that you want to hide. Steven wrote: 1) I have 2 fields in the Row section of the Pivot Table. Is there a way to set it up so you don't have a total at the end of each value change in the first field of the row section? I dont want any subtotals totals; just the grand total. 2) Is there a way to tell the pivot table that on the columns not show the blank or empty columns? Thank you for your help, Steven -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
synchronising pivot tables | Excel Discussion (Misc queries) | |||
Need to create multiple Pivot tables at once | Excel Discussion (Misc queries) | |||
#REF in Sheets that refer to Pivot Tables | Excel Discussion (Misc queries) | |||
Dynamically changing several pivot tables at once | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) |