Top N

v-huizhn-msftChihiro

the thing about all this is: I do have 3 different tables:

LAKENN (this one includes the country codes)

PG (this one contains the product group name)

RE2015 (this one includes the turnover for the year 2015)

Here's a screenshot regarding the relationships between the tables:

What i exactly need is: I want to show the top 10 figures by turnover by country (in monetary figure and in percentage of the whole turnover sum) for the specific product group. In case I choose the Top-N Filter for the top 10 product groups filtered by RE2015 (the turnover for the year 2015) the turnover figure by group is changed to point only out to the whole sum of the top 10, not all figures including the ones, which aren't shown due to the filter. Also the percentage changes only based on the total of the top 10 and not on all figures, including the ones which are not shown while filtered out.

Does anyone has a clue how to solve this problem?

I think all your suggestions might not work,