Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable Question
Hello and good morning.
I have created a pivot table where the row contains Dept and Name and the columns contain 0% Sal, 3% Sal, & 5% Sal. Since I have name in my row, there are many names that are Zero's for all of the column headings (due to allocations). How do streamline the data to show only the values in the column greater than zero? I appreciate any help on this. Rich |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
QUESTION: Copy pivottable from excel file to another. | Excel Discussion (Misc queries) | |||
PivotTable Question | Excel Discussion (Misc queries) | |||
Dynamic parameterized PivotTable update? | Excel Discussion (Misc queries) | |||
Pivot table question | Excel Discussion (Misc queries) | |||
PivotTable question | Excel Discussion (Misc queries) |