I have requirement is i need the top ten gross sales for the accounts and i want the remaining all account gross sales come in 11 row only
ex: i have 100 rows, top 10 gross sales in first 10 rows and 11 row is total gross sales from 11 row to 100 rows.
Please suggest me.
Using Selection steps we can achieve this... bt here we should take hard coded value (Like using BINS).
-in this case i was taken prod, revenue(sort desc)
-- select selection steps:
prod col: Then, New Step...-> Add Groups or Calculated Items -> new calculated item
Display label name: Remaining sum(11-100)
select products which are not in top 10 i.e, 11 to 100 records(move all then remove top 10)
check the "Remove calculated item members from view"
I was struggling with this problem ....specially in OBIEE 11g it's kind of tricky...and a few things needs to be taken care........here is the link which worked finally for me after wasting almost 1 working day to break it thru