Power Pivot Drill Down Page Headers 2

[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 contains a heading like this:-

Data returned for Count of NAME, CS (First 100000 rows).

We then have a blank row and data headers start at row 3.

Is there a drill down setting that will eliminate this 1st heading (in row 1 & 2) and return the raw data headers (currently in row 3) in row 1? (Not seeking any VBA solutions. Just native Excel).

Hope that made sense

Thanks

 

[Matt Allington]

Do you mean double click on a "value" in the pivot, and look at the table result? I hate it it power pivot and never use it. If you hate it too, then we are aligned.