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.