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
Explain the difference between union and group?
Explain about a tricky situation for which you found a very simple solution?
Differences between business objects and web intelligence reports?
What we need to discuss with designer before starting the universe designing.
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
How to create Index to the table in the universe designer and how it improves the Query performence
how to create reports on screech?
Which versions are used in the bo dashboard work?
Give some information on report bursting?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
how get the grand total in master-detail report?
What is package in BO
Explain what are the measure objects?
What is difference between custom hierarchy and report based hierarchy?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com