Skip to Content

Top 10,Other and Total in Webi

Jan 22 at 03:30 PM


avatar image
Former Member

I have a Webi report, i have created Top 10 based on ranking. now i need to Total.

PB means i have to match the Series in excel if its there then i can bring the data in PB section, if its not there then i need to bring in PNB section.

I have used PB filter in PB section of report and Same for PNB

Now the Top 10 for PB is 16451 and Total i want all the rest of PB numbers Which is (16707).

I have used =NoFilter([V_LWeek_Val_Ebook];Drill), but its giving me all the data.

i have attached the result. please anyone is there to help me. i am struggling to fix this frm last 3 weeks

capture.jpg (173.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers