software

1) In a pivot table with mutliple quot;row fieldsquot; 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!

#1. Pivottables don't work that way. You could convert it to text and fill
those cells, though.

Debra Dalgleish has some techniques at:
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,quot;Hidequot;,quot;showquot;)

then use that field in the page field of the pivottable. I can choose to see
only the quot;Showsquot;.

JenL wrote:
gt;
gt; 1) In a pivot table with mutliple quot;row fieldsquot; I need the data label for
gt; each row field to repeat on each and every line instead of grouping them with
gt; blank cells between each unique row field.
gt;
gt; 2) Also, I have multiple data items as well. If the value is zero or
gt; blank, is there a way to make that value for the person not show up at all
gt; instead of a line with a blank or zero value?
gt;
gt; I know this data would be better managed in Access....but our company does
gt; not let us use that program.
gt; Thanks!

--

Dave Peterson