We are working with an issue where we have a line chart and in the chart we have
Measure: Extended sales
Category : Calender week
Series: warehouse
We are getting the total Extended sales for week for a particular warehouse.
Our requirement is to get the Total extended sales for a particular sales Rep which includes few warehouses into the line chart. User wants to compare the total line with the line showing sales for a particular warehouse. When I bring the sales rep into the series, the chart is just concatenating the warehouse number with sales rep number with just single line showing in the graph. We are using the line chart "Line with 3D visual effect". We are working on reportnet 1.1.
Thanks