Question: When I build a pivot able, and have 2 or more sets of row labels, the label to the left only shows once. How do I fill the data in columns in a pivot table?
To make this work, you need to be in the Classic Pivot Table view see this blog post for instructions on how to convert to the classic pivot table view: http://businesstoolsblog.com/2011/05/display-pivot-tables-with-the-row-labels-side-by-side-instead-of-in-one-column/
In a standard pivot table the row labels after the first row label are blank, like this:
If you want the row labels to appear on each row of your pivot table, so it looks like this:
Right click on the pivot table and select “Field Settings”
Then select the “Layout and Print” tab; check the box next to “Repeat item labels” and click “OK”
Your pivot table will now look like this:
Formatting this way is great if you need to use the data in the pivot tables for additional analysis.
If you liked my post, feel free to subscribe to my rss feeds
BlogoSquare
4 Comments so far (Add 1 more)