question

First thing is to get your data into shape. A line chart in SSRS needs a value column (revenue in your case), columns for "category groups" (the x axis). You'll probably want this to be time (a column for months and one for years will do nicely). Finally you'll want (probably) one column for series groups. I think you're referring to these as divisions. By the look of the table above, I don't think you have your data structured for this at the moment. I have mocked up a quick and dirty query based on AdventureWorksDW2012 as an example. SELECT shd.EnglishMonthName AS ship_month ,shd.CalendarYear AS ship_year ,dst.SalesTerritoryCountry AS sales_country ,max(shd.FullDateAlternateKey) AS mth_sort --Just a way to get the various countries to have different amounts. This is really unconvincing demo data. ,sum(CASE WHEN dst.SalesTerritoryCountry = 'Australia' THEN frs.SalesAmount WHEN dst.SalesTerritoryCountry = 'Canada' THEN frs.SalesAmount + 200 WHEN dst.SalesTerritoryCountry = 'France' THEN frs.SalesAmount + 450 WHEN dst.SalesTerritoryCountry = 'Germany' THEN frs.SalesAmount + 710 ELSE 0 END ) AS sales_amount FROM dbo.FactResellerSales frs JOIN dbo.DimDate shd ON frs.ShipDateKey = shd.DateKey JOIN dbo.DimSalesTerritory dst ON frs.SalesTerritoryKey = frs.SalesTerritoryKey WHERE shd.CalendarYear = '2006' AND dst.SalesTerritoryCountry ]]]]]]