Displaying both grid and graph in the same view
When looking at a report grid you have the option to switch to Graph View by clicking on the View | Graph View menu.
If you save the report while in Graph View, it will be saved as a graph.
Getting ready
We'll start with an easy one; create a report of Sum SalesAmount from FactResellerSales by Country. Since in the FactResellerSales table we don't have a Country FK, we need to create a Reseller attribute that links the fact table to the Country dimension. At this point, you should already know how to do it. Remember to select the correct columns for the ID and set the Reseller attribute as a child of Country.
How to do it...
Once you have the report on grid view, save it as 21 Reseller Sales by Country, then:
From the View menu, click on Graph View.
When the Graph Type selection window appears, leave the default Vertical Bar:Clustered selected and click on OK.
From the File menu, select Save As and give it the name
21 Reseller Sales by Country Graph...
