Power Pivot Drill Down Page Headers

[hoppermr2004]

I am using a 'Power Pivot' pivot table (Excel 2013). When a user double clicks on a pivot data value, the drill down tab yields columns that are prefixed with the table name and a field name in [].

eg [$Table_ASSETBALANCES].[NAME]

Is there a drill down setting that will return the pivot tables original column name in the drill down tab and not the cumbersome column name above?

In the eg above it would simply be NAME.

If not, does anyone have VBA that will eliminate [$Table_ASSETBALANCES].[ and the last character ] from the column headers in the drill down that is dynamic? ie will work without the user specifying the table name.

Much Obliged

 

[karim muhtasib]

I have a simple workaround that mostly helps getting over this insanely ugly functionality. So here it goes:

- From the PowerPivot window (data view), edit (by double clicking) the tab's name at the bottom of the screen and change to the number "1". This way, the drill down result will display 1(column name). Obviously the name edit needs to be done on the tab (data set) being drilled down on. Check out the before and after below:

vs.

Hope this helps. Unfortunately a blank space will not work so it makes sense to use numbers.

also posted here: Change Power Pivot Drill Down Column Headings