Cubeset based on 2 slicers

[zico_sailcat]

Hi there,

Im trying to define a cubeset based on 2 slicers but can't seem to get it to work.

Say you have a set of product numbers (product_number) and each of these is sold in different countries (product_country)

What I want is to have 2 slicers enabling you to define a cubeset through a combination of product_number and product_country.

I was thinking that something like this might do the trick:

=CUBESET("PowerPivot Data";(Slicer_Product_number; Slicer_Product_country);"Cubeset")


which it obviously didn't.

Is there a way to do this or am I forever lost?

Cheers

 

[j0nthn]

Bump, would love to know whether you or someone else has figured this out..

 

[ImkeF]

Don't know how to do this, but this workaround might work for your purposes: Excel Cubefunctions: Trick for dynamic sets – The BIccountant