The solution was to use the NTILE function. She divided the results into selected numbers of groups.

I know but I was wondering if there is any chance to use something like sql code CASE WHEN or something in new column to get this result. OK thx for help

i need view like this.

by using this: @{title or adres} in title line?

So this option is useless if we use a list of value and we don't want to take other value (not from our list)? I was hope that I can give users an options to mark all or non value in one click (whitout create another presentation filter).

it is part of an application mycompany bought (Oracle Biee 12c) and I ask about any option of modification for this opction

But this will create 2 emails - I need one message with attachement and body.

OK but could you show me how to chain agent's on some example? Some images will by helpful.

Such an exhausting response This should solve my problem. Thank you. And thx for a good tips!

OK but I need to keep a value like 20, 10 etc in tabel body and get only a summary for how many value under 20 i have. Is this solution (that you give) give me that result? And the noob question - how to change a view on a union query ? Did you mean a edition of the formula? Or change a view in result tabel mode? P.S. The…