How To Use CUBEVALUE To Alter The Layout Of A PivotTable In Excel

In this tutorial we’ll take a look at how you can use the CUBEVALUE function in Excel to allow more flexibility with laying out your PivotTables.

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

I have a data set of 2,000 lines:

And I want to be able to create a layout using PivotTable data that looks like this:

Normally, you are somewhat constrained by the use of PivotTables to move blocks of data around, insert blank rows and the like. But, in order to accomplish this, we’re going to convert our PivotTable into formulas. Take a few minutes and watch this video to see how easy this can be!

What can you do next?
Share this post with others that can benefit from it!
Leave a comment or reply below – let me know what you think!
Subscribe to this blog for more great tips in the future!
Check out my YouTube channel – click on the YouTube icon below!

Happy Excelling!

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

No comments yet.

Leave a Reply