How to repeat row labels on Pivot Table in Microsoft Excel
- 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.
Re: How to repeat row labels on Pivot Table in Microsoft Excel
There are certain assumptions from my side :
- Pivot tables don't work that way. You could convert it to text and fill those cells, though.
- I am not sure you can hide the 0 values. But after you convert it to text, you can do anything you want.
Sometimes I 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. So try this out =if(a2=0,"Hide","show") then use that field in the page field of the pivot table. I can choose to see only the "Shows".
Re: How to repeat row labels on Pivot Table in Microsoft Excel
Look in the PivotTable Options tab layout and format. There is an option "Automatically adjust column widths on update 'of mW which is checked by default. Take the hook to get out and test the whole thing.
Repeat item labels in a PivotTable report