TM1 Forum

Your syntax is invalid, you can't do a TOPCOUNT based on adding two nodes together using a plus sign in the MDX. My guess is you were tricked into thinking it was working because the TOPCOUNT for [Blah].[Curryear] probably returned the same set as what you were expecting to see when adding CurrYear...

Well, I belive consolidating the elements within the dimension would work, however I would rather not pollute the nice and easy dimension with such consolidation....
In any case thanks for your reply, I would take this as a last resort workaround

Hello I'm playing with TopCount mdx subset, and trying to get TopCount based on sum of current and previous year. It seemed straightforward, so I used { TOPCOUNT( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [Product] )}, 0)}, 10, [Test].([Blah].[CurrYear]) + [Test].([Blah].[PrevYear]))} and it worked really w...

Hi All I'd like to find top customers for multiple products within a single query, e.g. topX customer for product A, topX for product B etc.... I was able to write an mdx query, which gets me the very top customer for each product, as follows with member [EDataSet_B].[Top1] AS 'TOPCOUNT(TM1FILTERBYL...