Well, since you can't mix aggregates and non-aggregates, you need to either make everything aggregate or make everything non-aggregate. For the first option, you could replace [Title] and [Top 20] by ATTR([Title]) and ATTR([Top 20]) respectively. Alternatively, you could create a FIXED LOD expression that pre-calculates your COUNTD([Title]).

Samuel,

I would assume you wanted something like this.

If so create a field called Index with Index() as the value inside it and then create another field lets call it Top Vs Bottom and define a If condition as below

if [Index] < 10 THEN 'Top 10'

ELSE 'Rest All'

END

Good Luck.

Samuel,

I am sorry but I missed it. Are you looking for a changing field name ? i.e if you have 300 obs then 'top 100' and then '200 others' or if you have 800 obs in total then 'top 100' and '700 others'

check this article out, it helped for me. I've also posted in this article some tweaks that I used to make mine make more sense.

Top N, with everyone else as "Other"

Create one more field to get the total count of Observations. I am using Super Store and the field I am using is Product Name. So a new field called Calculation3 which is as below (considering you wanted Top 20 and Rest. Change the value of 20 accordingly)

STR('Other ') +

STR({EXCLUDE [Product Name] : COUNTD([Product Name]) } - 20)

then change the formula for the field 'Top vs Bottom' as below.

if [Index] < 10 THEN 'Top 10'

ELSE ATTR([Calculation3])

END

This will change the Title as and when the number of Observations changes.

Good Luck.