How to display the top 5 records along with the additional
records,plus their sub and grand totals to be display in the
same block.

Answer Posted / anand

*1st step-* expression topcount([Products],5,[Revenue])
*2nd step-*then i will select this expression in detail
filter condition
like ([data item1])< 5
OR directly will double click on Measure column and write
it down this condition.

Is This Answer Correct ?    0 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

3925


Is there any other repository domains rather than universe, security, document?

600


Explain the data types present in bo and what happens if we implement view in the designer and report?

564


How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

1972


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1725






Give some information on report bursting?

572


Explain what is the difference between slice and dice and cross tab report?

608


Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

543


What is a fantrap in business objects?

582


Explain when we use aggregate awareness function in designer?

590


Explain is there any default username & pwd for bo designer & supervisor?

599


Explain what task is 98% of the required work of a business analyst?

603


can anybody tell me about complicated object you have created

2755


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

1759


What is package in BO

2685