Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
#1. Pivottables don't work that way. You could convert it to text and fill
those cells, though. Debra Dalgleish has some techniques at: http://www.contextures.com/xlDataEntry02.html #2. I'm not sure you can hide the 0 values. But after you convert it to text, you can do anything you want. I sometimes do this to hide/show what I want. I'll insert another column and create a formula that determines if that row should be shown or hidden. =if(a2=0,"Hide","show") then use that field in the page field of the pivottable. I can choose to see only the "Shows". JenL wrote: 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! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |