Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Click-through? Expand / Collapse
Author
Message
Posted Wednesday, November 16, 2011 3:46 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, August 8, 2016 2:45 AM
Points: 815, Visits: 660
Normal excel pivot tables allow the user to double-click a datum to extract the underlying data into a new worksheet. Is this available in Powerpivot at all?
Post #1206520
Posted Wednesday, November 16, 2011 4:05 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 1:36 AM
Points: 15,289, Visits: 13,074
The underlying data is in the PowerPivot model. You can access this by clicking on the PowerPivot Window button.

If you just want to look at the data, that should be sufficient.
If you want to export the data, you can use a regular PivotTable to connect to the datasource and do the export.

(I do not known if there is a feature in PowerPivot that is exactly the same as in a regular Pivot, but I don't have PowerPivot on this machine, so I can't check it now).




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1206528
Posted Wednesday, November 16, 2011 4:08 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 1:36 AM
Points: 15,289, Visits: 13,074
Did a bit of research, and I found this:

http://social.msdn.microsoft.com/Forums/vi-VN/sqlkjpowerpointforsharepoint/thread/c19a0d0e-a131-4b6b-8e9a-63cbf4d394bd

There is no drill-through, but with a bit of a workaround using regular PivotTables you can achieve somewhat the same result.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1206529
Posted Wednesday, November 16, 2011 4:11 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, August 8, 2016 2:45 AM
Points: 815, Visits: 660
That workaround will be fine - thanks a lot for the help. I figured drill-through isn't available as the volume of data returned could exceed the max row count in Excel.
Post #1206531
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse