Drilled Down/Drilled Up Reports in SharePoint using Power View

I have an excel file where there are multiple excel sheets like Master Sheet and Detail Sheet,KPI etc etc.I want to actually use these excel sheets to create reports with charts using any of the following:

  • Excel PivotTables
  • Power View
  • Excel Services

There are so many records against each item like one parent record has 50 child records

What i want to know the best approach among the above mentioned techniques but with the following functionality

Drilled Down/Drilled Up approach

Then we have to deploy those reports in share point site as well.So please suggest.

February 2nd, 2015 5:20am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics