In the PowerPivot documentation:
"Edit a Hierarchy
You can rename a hierarchy, rename a child level, change the order of the child levels, add additional columns as child levels, remove a child level from a hierarchy, show the source name of a child level (the column name), and hide a child level if it has the same name as the hierarchy parent level. "
Yet it never explains how to do this. If I right-click on the hierarchy, there is nothing in the context menu to do this.
Does anyone know how this is done?
Thanks in advance.
Sorry that you didnt find the documentation clear enough.
You need to be in PowerPivot Diagram View to do these - in your PowerPivot window, click the 'diagram' icon on the right bottom corner.
-- This posting is provided "AS IS" with no warranties, and confers no rights
Yes, I realize that you have to be in Diagram View; that is not the issue. The problem is, there is nothing in the documentation that explains how to "hide a child level if it has the same name as the hierarchy parent level". The documentation ends with this:
To hide or show a source name
Right-click a hierarchy child level, and then click Hide Source Column Name or Show Source Column Name to toggle between the two options.
When you click Show Source Column Name, the name of the column that it was copied from appears to the right of the child level.
I need to know how to "hide a child level if it has the same name as the hierarchy parent level". Can you tell me how to do that Chu?
Thanks in advance for the help.