I have a pivot table created using Power Pivot. When I double click a total field, I get the expected new tab with the detail rows behind the total. However, one column is missing from the detail table i.e. all columns except one are displayed and the missing one is the unique identifier for a given row. Is this a known issue or is there a way to add the missing column to the drill down table?

Thanks

Hi,

Sorry for my poor understanding, what does 'the unique identifier for a given row' mean? Could you please share a sample workbook with us?
I created a PowerPivot using the SQL Server database  as the data source ,create a pivot table,then drill down in the pivot table, I can get all of the columns including the GUID column.

Wind Zhang
TechNet Community Support

I have the exact same issue as noted above! Any known solution? Thanks