SSRS Scatter Chart

DataSet

SELECT        1 AS RowNumber, '2007' AS x, 48123 AS y, 33 AS others
UNION ALL
SELECT        2 AS Expr1, '2007' AS x, 52000 AS y, 44 AS Expr2
UNION ALL
SELECT        3 AS Expr1, '2009' AS x, 62000 AS y, 55 AS Expr2
UNION ALL
SELECT        4 AS Expr1, '2010' AS x, 42000 AS y, 66 AS Expr2
UNION ALL
SELECT        5 AS Expr1, '2011' AS x, 22000 AS y, 77 AS Expr2

1.Default Behaviors

when add "y" as ∑ value, Category Groups will auto Add "Details" and ∑ value Add "Sum(y)" and "X Value"

∑ value:  the chart data area, include Y and X, those value come from Dataset

-"Sum(y)": Y-axis value

-"X Value": X-axis Value. if the Dataset only include two numeric columns, then "X Value" will smart enough to auto use the other column's value except "Y value", but if Dataset Includes more than 2 numeric columns(in this case, we have column "x","y","others" which is greater than 2 numeric columns), then "X Value" will be the row number (start from 0). Other than use "X Value", we can choose specific column as our real X-axis Value.

 or 

Category Group: do the group by in Dataset

-"Details":no group by, if we use value other than "Details", then will do the group by, at the mean time,  ∑ value will need to use aggregate function.

2. Category Field vs. Category Group

  vs  

Category Field: X-axis of Dataset

Category Group: Group by on Dataset