EXCEL PRO TIP: CUBE Functions

[@carolinecostaBR]

Amazing class, thank you!

[@wayneedmondson1065]

Hi Chris.. super interesting video. Lots of power in those CUBE functions when you want to customize the output beyond a standard Pivot Table. Thanks for the insights. Thumbs up!!

[@ptatanasov]

Excellent tutorial, thanks a lot for sharing it! I have a suggestion when setting up ranking with Cubemember... instead of ranking the numbers in column a from 2 to 6, you can set the parameter “A17+1”.

[@youjohnny16]

Maven rocks.

[@LotfyKozman]

Well well well done, we need more about CUBE Function, unfortunately this function doesn't have its luck within Excel or powerpivot.

[@republikadugave420]

7:40 holds true if you insert a cubemember into a cubevalue formula and reference a cell in square bracket followed by "&C4&"for example... i actually use this trick to change things cubevelue is referencing with data validation list..

[@eriknegron1047]

@ 8.35 the value updated before making April a Cube member, how did that happen? kzbin.info/www/bejne/emS1o4ykqc2oiaM