World Sales Dashboard template

Let's see how create a  simple Sales Dashboard  which has as main component the

Accordion menu
which allows to have a multiple level hierarchical filtering.
This means that you can first select the top level hierarchy dimension in our case the 'Country' and then you can choose one of the 'Products' sold in the selected country:

The columns chart shows the sales for that kind of bike in the months of the year.

In the following image you will see how data changed when you select an other kind of product

Below  you can see how create the Excel file in order to create this dashboard.
In the yellow are will be drilled the months sale data after selecting the two hierarchical dimensions.
Under this line there are different tables for each Country that can be selected which contains sales data per product for each months.

Below is detailed how to set the Accordion Menu

You can find the related files on SAP COMMUNITY NETWORK,
in the following link another example with related files:

USING THE ACCORDION MENU

For  more Dashboards templates and example:

Xcelsius Dashboard template files


XCELSIUS SALES DASHBOARD TEMPLATE