POWERPIVOT: Unable to drill down from pivot

EdwinPWP

New member
Joined
Jan 5, 2012
Messages
2
Reaction score
0
Points
0
Ok so I finally build my pivot table using PowerPivot. Im looking at the pivot and I would like to drill down the pivot so that I can see a query of the value.

Seems like the people from Microsoft forgot to put this feature.

Let me get this straight. Power to the Pivot, as in a better Pivot table. In regular Pivot tables you can drill down by double clicking the value inside the pivot. But in PowerPivot you cannot?

Can someone please clarify if Im missing something, maybe a switch that I need to enable so I can drill down a query from the pivot table.:confused2:
 

JoePublic

Super Moderator
Staff member
Joined
Sep 16, 2011
Messages
222
Reaction score
1
Points
18
Location
UK
Excel Version(s)
2016
To the best of my knowledge, it was simply not included in v1 of PowerPivot.
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,521
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Nope, doesn't work in PowerPivot v1. It does work in the RC of PowerPivot v2 though. Hopefully it won't be too long before they release the final version of v2. :)
 
Top