Is it possible to reverse PowerPivot Cube Formulas back to its orginal form

Xceller

Active Member
Joined
Aug 24, 2009
Messages
265
Hi everyone - I converted a PowerPivot report into the Cube Formulas format so I can cut/slice data, but the PowerPivot Field List / Drop zones are gone. Is it possible to get the Field List window back?
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Hi Xceller

Once you convert to cube formulas, there is no way to go back to a pivot table (and hence, the the field list). That is, unless you start a pivot table from zero again. Having said that, you *can* still use pivot table generated objects against cube formulas, like slicers and filters.

Javier Guillen
Senior BI Consultant
PowerPivot Blog: http://javierguillen.wordpress.com
Twitter: @javiguillen
 
Last edited:
Upvote 0
Hi Xceller

Once you convert to cube formulas, there is no way to go back to a pivot table (and hence, the the field list). That is, unless you start a pivot table from zero again. Having said that, you *can* still use pivot table generated objects against cube formulas, like slicers and filters.

Javier Guillen
Senior BI Consultant
PowerPivot Blog: http://javierguillen.wordpress.com
Twitter: @javiguillen

Javier - Thank you for your reply. It would have been nice if this is possible because if a field or something needs to be added or adjusted after the pivot table has been built.
 
Upvote 0
Hi Xceller,

You can still manually use Cube functions to retrieve PowerPivot data after you have converted your pivot table into formulas. In other words, converting to formulas is not the end point, you can still use functions like CUBERANKEDMEMBER and CUBEVALUE to continue from the point your left off and in that way add more data elements to your spreadsheet


Javier Guillen
Senior Consultant, Mariner
Email: javier.guillen@mariner-usa.com
PowerPivot Blog: http://javierguillen.wordpress.com
Twitter: @javiguillen
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,267
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top