Extracting static data from powerpivot without pivot tables

[masplin]

I started with an excel table as follows

User ID Static1 Static2

I linked to powerpivot and created a bunch of calculated measures so powerpivot window looks like

UserID Static Static2 Calc1 Calc2 etc

I want to output the powerpivot back into excel with the same headings just as rows of data. As far as I know pivot tables cannot output values like names just a count of names or similar. So far the only way I can do it is to copy the whole of the powerpivot window into excel and then format it, but all numbers come out as text.

Is there an intelligent way to output the powerpivot raw data?

 

[scottsen]

Well, they were trying to show all rows by aggregating on some field. So, if there are fewer rows to aggregate on, you would be fine. Otherwise... ya, any time you are on excel sheets you are constrained by the row limit.

 

[potap]

I have powerpivot v11 and I double clicked on values area in pivot table field list and nothing happens. Please let me know if I am doing anything wrong. I wanted to transfer powerpivot data as it is to excel so that I can use it for tableau as data source. Thanks

I have the same problem! Is this supposed to work in Excel 2010?

Edit : Ok, got it to work but my table header is in this format Table1[Column1], Table1[Column2], etc. Can I get rid of the Table1?