Calculate top 10 record correlation

[#1]

I have 2 straight table, one is display the list of dates, total customer count, total products count and the how much sales we have on that date. another straight table use to display the correlation between sales and customer count, product count.

now user is asking to add the filter so that they can choose to display the recent 5, 10, 15 and 20 dates of data only.

This is very easy to achieve in the 1st straight table, all I need to do is set a dimension limits on the date.

but for the 2nd chart, how can i calculate the correlations for the first N number of dates???

[tresesco]

You possibly have to use Rank(). Post a sample qvw to get more specific answer.

[satishkurra]

Use below expression in Calculated dimension

=if(Aggr(Rank(Sum(Sales)), Customer) <=10, Customer)