Top and bottom 10 records

[Sarayucog]

Hi all,

I have a report to find out the top and bottom 10 records.

My model contains some relational query subjects and some dimensional query subjects.

In my report I have 1 list and 1 chart for top 10 rows and 1 list and 1 chart for bottom 10 rows and all the reports objects are assigned to the same query. Same query items are taken into the list and chart reports.

I have drill up and drill down on Region column (It is dimensional query subject). When I am runniing drill up and drill down are working fine, but when drilling down to the lower values like countries, states etc the chart report is showing 10 records, but list report is displaying more that 10 records. Please tell me why it is.

I have used topcount() and bottomcount() functions to find out the top and bottom 10 records.

Your help will be appriciated more.

Thanks in advance...