[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 186
  • Last Modified:

Excel 2010 - Pivot categories

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
0
csehz
Asked:
csehz
1 Solution
 
Patrick MatthewsCommented:
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.
0
 
csehzIT consultantAuthor Commented:
Patrick sorry for the late check just the weekend started, this works perfectly to me

thanks,
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now