Thank you Shinichiro!
One more questions - Can I do Top 10 as well as combine the remaining in same chart as Others?
Thanks again for your help,
Could you mark "correct answer" to show it's answered.
And yes, you can. use SET instead of filtering. (You need to remove filter)
[Top X Detail]
if [Set Top10] then [Traffic Source Detail] else "_Other" end
(I put "_" to sort name easily with putting other on top)
Put field [Top X Detail] into color shelf.
Sample (2) rep2.twbx 45.0 KB
Please have a look. It may be helpful.
If Index ()<= [ Show N Values] Then "Top N"
elseif Index () > (SIZE()- [ Show N Values]) then "Bottom N"
Else Str(SIZE()- 2*[ Show N Values])+Space(1)+ "others" End
if you want to follow the Set approach then see below
Top N values.twbx 1.0 MB