Top 9 and 'others' in Infoview

wow! stubborn little child!

anyways… you did not search the forum that well… here’s the answer!

=If(IsError(If(Rank(<measure>;<dimension>) < 3;<dimension>;"Other") In(<dimension>));"OTHER";If(Rank(<measure>;<dimension>) < 3;<dimension>;"Other") In(<dimension>)) 

you can find the answer here: https://bobj-board.org/t/139201

READ THE TOPIC THOROUGHLY.


R.A. :philippines: (BOB member since 2008-10-28)