Basic Power Pivot Question

[jimimid]

I am very new to Power Pivot but have been working with pivot tables for years. I have a spreadsheet where I would like to group or sum the rows based on a column. If I create a pivot table and make the rows the column id it would naturally do what I want and sum any columns place in the values box. I can then just copy all the data and paste to a spreadsheet to get what I want. Ideally I would rather have the data stay in a regular sheet so that I can do further analysis on the sheet and not through a pivot table. My question: Does power pivot read the data on a spreadsheet and allow you to group based on a column and dump that into a new spreadsheet ?

 

[Smitty]

Welcome to the Board!

Once you put your PowerPivot data into a Pivot Table it will work exactly the same as a normal Pivot Table, so I don't see why you can't reproduce what you do with regular PT's.

 

[jimimid]

Thank you. So PowerPivot wont take the data aggregate it and let you export back into a regular sheet ? Old fashioned copy and paste from the pivot table is the way to go ?

 

[Smitty]

You should be able to copy/paste provided you don't hit the row limit. This article might be of use:

Aggregations in PowerPivot - Excel - Office.com

 

[powerpivotpro]

In Excel 2013 you can also query the Power Pivot model via DAX Queries, and land the results in a normal Table, just like a Query Table. I personally have not done that, but there are many folks who have and a quick google on DAX Query Tables should probably get you started.