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”.
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!!
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..
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”.
Amazing class, thank you!
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!!
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..
Well well well done, we need more about CUBE Function, unfortunately this function doesn't have its luck within Excel or powerpivot.
Maven rocks.
@ 8.35 the value updated before making April a Cube member, how did that happen? th-cam.com/video/D3RrYnthuSA/w-d-xo.html