New To Pivot Tables

[Guzzlr]

I have my pivot table, and when I hover over the field, I see the field area for that particular input. How do I get those words to show on the pivot table, so I dont have to hover over it?
Thanks

 

[RoryA]

You can do it on a per field basis by right-clicking the field and choosing Field Settings, then set it on the Layout & Print tab, or do it for all fields using the Design tab in the PivotTable Tools group, by clicking the Report Layout dropdown, then Repeat All Item Labels.

 

[chrism216]

When I click on the pivot, that brings up the "Pivot Table Field List" what I would like is to have excel state in the Row List what is listed when hovering over it, that way you need not hover, it is automatically written out. Kind of hard to describe.

You have to double click any value field in the pivot table, not a column or row field. Those will bring up the pivot table field list as you said. double clicking a value field (for example a sum field) will open up a new tab containinng only the rows used to calculate that particular field. By the same logic, if you double click the grand total, it will display all rows used in the entire pivot table.

 

[Guzzlr]

You can do it on a per field basis by right-clicking the field and choosing Field Settings, then set it on the Layout & Print tab, or do it for all fields using the Design tab in the PivotTable Tools group, by clicking the Report Layout dropdown, then Repeat All Item Labels.

Here's what I did;
1. I right clicked on one of the entries in "Row Labels"
2. I selected Field Settings
3. Clicked on the Layout & Print tab
4. Selected the check box Repeat Item Labels and clicked OK

But I dont see what that did? I still have to hover over the entries to find out which filed the number belongs to.

 

[RoryA]

It means that the label repeats for each row so you should be able to see which row/column items an entry belongs to simply by scanning across or up.