- In a pivot table with multiple "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.
- 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 to 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.
Bookmarks