Excel 2010 - Pivot categories

csehz
csehz used Ask the Experts™
on
Dear Experts,

Could you please have a short look on the attached pivot, is there maybe some settings with in cell A7 would be B, and in cells A9:A10 the C character?

Briefly that instead of the blank, in each cell should be the Category

thanks,
PivotCategoriesFilled.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010
Commented:
Select your PivotTable.  Now go to PivotTable Tools / Design in the Ribbon.

Click Report Layout, and select Repeat All Item Labels.

This only works in Excel 2010, and does not exist in prior versions.
csehzIT consultant

Author

Commented:
Patrick sorry for the late check just the weekend started, this works perfectly to me

thanks,

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial