help with database structure

[#1]

Good morning!  I have a problem
I need to do a chart type drill down to the previous data table structure
The drill down would be of two types:
*  country -> region -> customer

*  country -> customer

any ideas?
thanks

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Go to the Settings menu, Document Properties, Groups and create a new drill down group. Add the dimensions Country, Region and Customer and save it.

When you create the chart, you will see how this group (preceded by an arrow icon) can be used so when you click on any country, you drill down to its regions, and when you click on a region, the chart drills down to its customers.

Hope that helps.

Miguel

[#3]

The new structure of the database is the following
leave as null the names of the missing areas
and drill down works perfectly in the dashboard
thank you very much