Drill down Functions in powerpivot

Question

Does powerpivot offer drill down functions?

Answer 1

you can create hierarchies and drill down the hierarchy path similar to what e.g. Analysis Services offers

---

- www.pmOne.com -

Answer 2

Hi Dionisis,

As Gerhard Brueckl said, most of the reports types and many of the features such as drill down require an Analysis Services cube as the data source. Here are some useful links for your reference.
PowerPivot Prototyping: Strengths and Weaknesses
Using Power Pivot and Power View for Profit Analysis

Hope this helps.

Regards,

---

Charlie Liao
TechNet Community Support