The requirement is to build Multi series line chart with Drill down.....overall all countries in region (7 countries)...countries to States...States to Towns.
I am trying to build dashboard, my objects (example) are date, country, state, town, Sales. Dates (14 days), Country(7 countries), States (36 states) Towns (more than 100).
When I build query component its gives me out put in Columns. But the report needs to be combination of rows and columns..
Town1 Town2 Town3
Date Country State X X X
I tried to build query and bring all the data into excel and building cross tab its huge database and report may not execute the dashbaord as its beyond 512 rows....14*7*36 3528 rows.
could any one help me on this..