C
cho
I'm tryimg to return record to view yearly production performance.
Then creating a line chart based to the record returned.Then I modify
the query builder become a crosstab query.(below are the query SQL ).
But why my chart cannot displayed the data correctly.My chart display
the data in separate chart ( one chart one dot ).Please help what is wrong.
Or I did a wrong step?
TRANSFORM Sum([Yearly DC Performance tbl Query].[NG Rate]) AS [SumOfNG Rate]
SELECT [Yearly DC Performance tbl Query].Month
FROM [Yearly DC Performance tbl Query]
GROUP BY Month([Month]), [Yearly DC Performance tbl Query].Month
ORDER BY Month([Month]), Year([Month])
PIVOT Year([Month]);
Then creating a line chart based to the record returned.Then I modify
the query builder become a crosstab query.(below are the query SQL ).
But why my chart cannot displayed the data correctly.My chart display
the data in separate chart ( one chart one dot ).Please help what is wrong.
Or I did a wrong step?
TRANSFORM Sum([Yearly DC Performance tbl Query].[NG Rate]) AS [SumOfNG Rate]
SELECT [Yearly DC Performance tbl Query].Month
FROM [Yearly DC Performance tbl Query]
GROUP BY Month([Month]), [Yearly DC Performance tbl Query].Month
ORDER BY Month([Month]), Year([Month])
PIVOT Year([Month]);