Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sorting and filtering on a line graph doesnt work ssrs Expand / Collapse
Author
Message
Posted Thursday, December 5, 2013 8:23 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 5:22 PM
Points: 58, Visits: 197
I need to create a line graph which shows top 10 Products which have made the highest sales for the current month and their trends the previous months.

My query for the dataset is something like this :

**select [Year], [Month]  , ProductName, Sales from ABC;**

I inserted an ssrs Line Chart with

Values :  Sum(Sales)

Category Group : Month

Series Groups : ProductName

I did a right click on the Series Groups and Changed the filtering and the sorting properties as below :

Filter :

Expression : Sales
Operator : Top N
Value = 10
Sorting :

Sort by : Sales Order by : Z to A

Logically , I expected to see the top 10 Products which have made the highest sales in the descending order , but I dont see that happenning.

Instead what I see is that the legend for the line graph is sorted in some random order and the first 10 products shown in the legend are only shown as part of the line graph. Can anyone tell me how I can resolve it ?

Let me know I can provide more details if needed.
Post #1520118
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse