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!
|