Click-through?

  • Ulysses_Infinity

    SSCrazy

    Points: 2586

    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?

  • Koen Verbeeck

    SSC Guru

    Points: 258905

    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).

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Koen Verbeeck

    SSC Guru

    Points: 258905

    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.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Ulysses_Infinity

    SSCrazy

    Points: 2586

    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.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply