So you have a bar chart by country and online/ offline and when you click on the country bar you need to see the top purchased product for that country ?
If that's the case, you can use fixed to calculate top purchased product for that country, bring that field and your country on to your sheet. Now, you will have top purchased product for each company in your sheet . Now you can add a dashboard action which filters just the country you selected from the bar chart.
Exactly. So on the columns shelf for the bar chart I've got
With a sum(profit) on the rows shelf.
This creates two bars per country. The need is to filter by either country OR country-online/offline. I think if I were to used a fixed LOD calc here it would only show me the top product for that country, not allowing me to further break that down by clicking on the countries' source.. Does that make sense?