CrossTab vs List when using functions !

[sanchoniathon]

Hi,

1- I create a list of 4 columns using the topCount function in one of the columns.
    It works fine.

2- The first column contains a calculation as follows and displays me the description of the products:
   topCount([Level];10;[Metric])

3- The idea is to have the top 10 products based on the metric named [Metric]

4- When i create a crossTab from that list (or a brand new cross tab from those columns)  i can't seem to have the correct results and i have not the top 10 products based on the [Metric].

Anyone has any ideay or suggestions or know any limitations with crossTabs ?

Thanks !