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:
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: