Cube functions

Resolved · Low Priority · Version 2010

Tue 20 Dec 2016, 18:08 Delegate Michael said...

Michael has attended:
Excel PowerPivot course

Cube functions

I can set 1 slider into my cube function but not multiple - it would be nice to be able to

Wed 21 Dec 2016, 09:20 Trainer Jens said...

RE: Cube functions

Hi Michael,

Thank you for the forum question.

We can work with multiple slicers in Cube functions. In the Cubevalue function you can refer to any number of slicers. In the example below I have used 3 slicers.

=CUBEVALUE("PowerPivot Data",CUBERANKEDMEMBER("PowerPivot Data",Slicer_INITIALS,1),CUBERANKEDMEMBER("PowerPivot Data",Slicer_Product,1),CUBERANKEDMEMBER("PowerPivot Data",Slicer_Year,1),"[Measures].[Total Sales]")

With some of the Cube functions you will need to return the value in a cell from the slicer and then refer to the value in the Cube function.

If this is not what you are looking for, Please specify your needs in more details.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Wed 28 Dec 2016: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Excel 2010 Shortcuts - Start and End of the Worksheet

Did you know you can quickly move to either the beginning or the end of an Excel Worksheet using just a couple of keys on the keyboard?

Press Ctrl + Home key to move the cursor to cell A1

Press Ctrl + End key to move the cursor to the end of the current worksheet.

View all Excel hints and tips