sql - Adding 2nd X Axis Data to Line Graphs in SSRS 2012 -

I am using SSRS 2012.

I have a simple dataset in which only 3 fields: date, name, quantity (not exact name but necessary details).

I want to create a simple line graph, showing the quantity for the date of each name.

So far, no problem, the name goes to the series group, the date range goes to the group and goes into the quantity values.

Here's the problem. I need to add the total amount in the form of the deficit line of data, but since the total is currently average between 300-350 per day, whereas no single name will be 75 days per day, I have to write the graph against the total X-axis with a second, different step

The SSRS can not automatically create a complete line from the underlying data from what I have read, so I changed the source query to create an 'all' entry to supply the total within the data Name.

However, what should I do to display in the graph to work for me? I have tried to add the name again as a series group and add another quantity to the value segment and have not worked properly

I have a different X axis with different steps How do I add the total line?

What you are looking for is called a secondary axis. It is actually quite easy.

Also, do not forget that you can have multiple datasets, instead of trying to adjust both data between primary and secondary axis, instead of modifying your first, Create a Dataset