Thanks for trying to help out. I think the error on the workbook is due to the pivot that i applied on the dates; you should be able to resolve it by pivoting dates on the date source. Let me know if that works.
But highly likely, the previous post of removing the link of "Country" work to show expected number.
But if you need to filter "Country", you should link. According to my experience, the primary data source's of country list and secondary data source's country list is different.
Removing the link to country still does not resolve the problem, unfortunately... The country list on the three data sources match perfectly. As shown in the screenshots below, the problem arises when the 'country' level of detail is taken off from the shelf - see below.
The country level gives the right value for 'online penetration' and 'online market'
At the aggregate level the values get wrong;
Thanks for trying to help.