Partial ranking

Hi all,

we need to create a report where there is a <i>partial</i> ranking, as in the following example:

              Qty        Ranking
Country1
  Material1   100 pc     2
  Material2   150 pc     1
  Material3   40 pc      3
  
Country2
  Material1   200 pc     1
  Material2   50 pc      3
  Material3   60 pc      2

However we can only get this report with Analyzer:

              Qty        Ranking
Country1
  Material1   100 pc     3
  Material2   150 pc     2
  Material3   40 pc      6
  
Country2
  Material1   200 pc     1
  Material2   50 pc      5
  Material3   60 pc      4

In this case, the ranking is <i>global</i>. Is there a way to get the desired result?

Cheers, Davide