Unmanaged Drill-Through
If the cube administrator does not configure the results to be returned, the default drill-through result worksheet will have one column for each measure defined by the cube administrator for that cube, not just those measures in the Excel PivotTable actually drilled through. The sheet will also, by default, have one column for the lowest level of the default hierarchy of each dimension referred to by the fact table. Associated captions rather than the raw keys will be shown.
The rows that appear in the drill-through results will be ordered according to the measure cell selected, in decreasing order.