locked
Automatically copy Pivot table info into excel table RRS feed

  • Question

  • Hi All,

        I have Pivot table which I would like to get into excel table.Can any one help me how can I achieve it.

    Thanks




    • Edited by SP Assest Friday, June 20, 2014 10:57 AM
    • Edited by Michael Amadi Sunday, June 22, 2014 10:15 PM Very minor amendment to title
    Friday, June 20, 2014 10:57 AM

Answers

All replies

  • Hi siddiqali,

    What do you mean with "automatically"? By the way this is related to Excel in general rather than Power Pivot.

    One (manual) way is to copy the entire Pivot table and to right click another sheet - past only values. That will create a normal Excel-table that corresponds to the values of your Pivot-table.

    The second option is to change the layout of your pivot-table to flat as described here: http://parasdoshi.com/2013/10/08/how-to-flatten-data-in-excel-pivot-table/

    That provides the advantage that the data will stay up-to-date without any additional copy & paste step.

    And finally you could just double-click the total cell - a nice list of the source data appears - see http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2011/11/03/how-to-show-pivot-table-data-in-flat-format.aspx

    I hope this helps!

    Julian


    Julian Wissel | BI for NAV @ http://en.navbi.com | Blog @ blog.navida.eu

    • Proposed as answer by Elvis Long Wednesday, June 25, 2014 7:48 AM
    • Marked as answer by Elvis Long Monday, June 30, 2014 1:59 AM
    Friday, June 20, 2014 7:07 PM
  • I think Linkback-Tables is the way to go

    http://www.sqlbi.com/articles/linkback-tables-in-powerpivot-for-excel-2013

    you can simply use EVALUATE('YourTable') to get the content of a whole table


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    Tuesday, June 24, 2014 7:51 AM
    Answerer