Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PIvot Table - Repeat Row Labels
1) In a pivot table with mutliple "row fields" I need the data label for
each row field to repeat on each and every line instead of grouping them with blank cells between each unique row field. 2) Also, I have multiple data items as well. If the value is zero or blank, is there a way to make that value for the person not show up at all instead of a line with a blank or zero value? I know this data would be better managed in Access....but our company does not let us use that program. :( Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
pivot table | Excel Discussion (Misc queries) | |||
external import of multiple worksheet data & create pivot table | Excel Worksheet Functions | |||
How do I repeat a value in a pivot table in Excel? | Excel Worksheet Functions | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) |