Hello.
I have been given a task which consists making excel power view charts from already given access database. As i started to do this task I quickly finished first part of first task, but then I realised I can't figgure out how to finish first task. I have tried several ways to do it, but I haven't fulfiled all necessary things.
My task is like this :
Create a Power View report with vertical bar charts showing total sales by calendar year
with a possibility to drill-down to month-level. The charts should be repeated by country2
(EnglishCountryRegionName) so that the charts for all countries should be visible
simultaneously. Which country had the largest sales in 2005 and which in 2008? In which
countries did sales rise in 2008 compared to 2007?
I have done the first part with drill-down, but I'm stuck on second part about country names and stats for them. I can't figure out how to link different tables in access to get data i need.
Database : 2015-04-09_iscocwm | Files.fm.
Task so far: 2015-04-09_zpbqerv | Files.fm.
Would realy appreciate any help with this task, as I'm new to office 2k13
I have been given a task which consists making excel power view charts from already given access database. As i started to do this task I quickly finished first part of first task, but then I realised I can't figgure out how to finish first task. I have tried several ways to do it, but I haven't fulfiled all necessary things.
My task is like this :
Create a Power View report with vertical bar charts showing total sales by calendar year
with a possibility to drill-down to month-level. The charts should be repeated by country2
(EnglishCountryRegionName) so that the charts for all countries should be visible
simultaneously. Which country had the largest sales in 2005 and which in 2008? In which
countries did sales rise in 2008 compared to 2007?
I have done the first part with drill-down, but I'm stuck on second part about country names and stats for them. I can't figure out how to link different tables in access to get data i need.
Database : 2015-04-09_iscocwm | Files.fm.
Task so far: 2015-04-09_zpbqerv | Files.fm.
Would realy appreciate any help with this task, as I'm new to office 2k13
