Hi,
I'm trying to create a bar chart and I have an SQL query that displays a customers name and the total number of orders they have for the month.
Customer Total Orders
ABC 150
DEF 25
GHI 75
The SQL Query is:
SELECT
[Customer Name],
Sum([Orders])
FROM dbo.[Delivery Log]
GROUP BY [Customer Name]
ORDER BY [Customer Name]
When I proceed to the Chart Parameters page, there are no options to select Data Series 1-4, only Label Field. What am I missing?
Thanks.