I have a report with a dimension which as four levels in it like the
following


MatGroup
Type
Blend
Color


Now when I run the Excel report the report only first shows at the
Matgroup level I need to go to each record and expand and display all
the nodes beneath it. All I want is the report to be displayed in a
expanded form at the Color level rather than at MatGroup level.


Appreciate if you could kindly point what setting needs to be enables
to have dimensions with multiple levels show all the nodes upto the
leaf node in the Excel pivot report.


Thanks
Karen