BusinessObjects Board

Calculate Average for all records without filter

building reports webintelligence
#1

Hi Experts,
I need your help for my report logic.

I have a table where i have brought AVG() and COUNT()
image

my requirements:

  1. The table should show only top 5 records. I used RANK column (it comes from universe) and applied as a filter. The table’s AVG() and COUNT() get changed.
    See RED circled in below picture.

How can i get AVG(), COUNT() of 7 records after the filter?
I used NoFilter(AVG()). But it shows #CONTEXT.

  1. Also i need to display remaining TotalCount() in the table.
    See YELLOW highlighted in below picture.
    ie., [Total_Count()] - [Top_5_Count()]

image

Please let me know if you have questions.

Thanks for your help.

regards,
K

#2

I found a solution for my scenario. All good.