Skip to Content
0
Former Member
May 21, 2009 at 01:39 PM

Dynamic filter by Country, month and year

36 Views

Hi,

I have a file extracted from SAP BI and incrusted in xls format in Xcelsius.

I have to filter data by Country, year, and month. I´ve seen the blog of Ingo Hilgefort 'Creating an Xcelsius dashboard on top of SAP BI that has a similar expanation of what I need to do.

Unfortunatelly, the problem I ´m facing is how to organize the data including the months in the spreadsheet incrusted in the Xcelsius.

What I have at the moment in the spreadsheet is a column with countries (9), an one column by KPI (10). Beside the last column I have the inserted data column for the countries so in the dashboard I can pick a country and shows me the KPI´s by country. What I still don´t found is how to make the selection also by month and year.

If anyone could help, I would be grateful.

Thanks in advance,

Diego