Filtered Raw Data from PowerPivot

[Gaurav_sham]

Hi All,

In our normal excel pivot, once I am looking data at summary level, if i click on any data value, it inserts the raw data for the value in a new sheet. This gives me the feasibility to look data only for a particular value.

In case of PowerPivot, do we have this option available. If yes, kindly advice.

Thanks & Regards
Gaurav

 

[Jacob Barnett]

Drill through is possible in PowerPivot although not totally straightforward if you are working with multiple tables. Have a look at this: drill through | Search Results | Javier Guillén