system
2
- Create a Detail object in WEBI
=If(IsError(
If(Rank([Sales revenue];[State]) < 6;[State];“Other”) In([State]))
;“OTHER”
;If(Rank([Sales revenue];[State]) < 6;[State];“Other”) In([State]))
- Place this object in the report.
- Place Sales revemue object beside this detail object of State.
- Turn table to chart (Pie or Bar), it works fine.
- You can set Asc or Desc on Sales Revenue object.
Thanks and Regards
Dilip Mhatre
assist (BOB member since 2006-04-17)