TM1 Forum

Hi,

I am trying to create an MDX filter on the "Customer" dimension based on revenue ("Measurements" dimension) for the 11-20th members.

I have 1 cube with 11 dimensions, which includes the Customer and Measurements dimensions.

I have found these two filters, which I believe I could use but I just don't know how to combine them. Any ideas?

{Subset ( {TM1FilterByLevel(TM1SubsetAll ( [Kund] ) , 2)}, 11, 10)}

{FILTER({TM1FILTERBYLEVEL( {TM1SUBSETALL( [Product] )}, 0)},
[Test].([Posting Measures].[Amount]) > 0 )}

Appreciate any guidance! Many thanks!

For example,
and you will want to restrict the selection in the Test cube more such as to come to the desired results. Select in the cube on year, period, scenario, ...

EXCEPT should do what you want
http://www.mdxpert.com/Functions/MDXFunction.aspx?f=113
ie (pseudo-code)
except([Top20],[Top10])