Drill through - Behaviour in PowerPivot/Pivot Table

[hananak]

Dear All,

I regularly use Power Pivot and Pivot tables for various analysis and drill through the figures to see what combination of transactions makes those figures. In my raw data there are 44 columns.

Every time I drill through, I get an exploded view of that table showing raw data - all 44 columns.

Out of the 44 columns that are retrieved, at least many columns are technical and does not provide any value to my analysis. Instead, I want to create a custom table to support a more customized drill through view, with only the columns I am interested in.

I have attached the picture of what currently I get when drill through and what I am interested in seeing.

Your help will be greatly appreciated.

Thanks.

 

[shift-del]

Drilldown in pivot tables will always give you every column. There is no setting to change that.

But you can provide feedback/ideas:

Community

 

[hananak]

Drilldown in pivot tables will always give you every column. There is no setting to change that.

But you can provide feedback/ideas:

Community

I managed to find one old post on internet, the Tutorial am struggling to understand fully.

If you could have a look, to see if possible via Power Pivot.

Any help would be appreciated.

Below is the link.

Configuring “drill to details” behavior in PowerPivot: Part 1

It has been said there is no way to change the default drill through behavior in PowerPivot. However, if we look closely we discover that we can actually exercise a bit more flexibility than norma…

javierguillen.wordpress.com

 

[shift-del]

So basically he is changing the pivot source.
You could do that with PQ: Import the source data, remove unwanted columns. load as pivot table to the worksheet.

 

[hananak]

So basically he is changing the pivot source.
You could do that with PQ: Import the source data, remove unwanted columns. load as pivot table to the worksheet.

Thanks for reply. Yes, that is the only way I can think of as well.

Cheers.