create pie chart with custom category from dataset
Hello All
I have a question about creating a pie chart which needs custom categorizinf from the data set in SSRS2008
below is the table that will be used as source of pie chart.
Task Title
Task duration (# of weeks spent)
Task 1
2
Task 2
5
Task 3
3
Task 4
7
Task 5
9
from the data set i need to set categories as below
Category1: duration (Number of weeks) 1 - 4
Category2: duration (Number of weeks) 5 - 8
Categpry 3: duration (Number of weeks) 9 - 12
Then the # of task for each category will be the value for the pie chart.
I need the help to set the custom category based on the # of weeks in duration column.
and need to set custom legend diaplaying 'Shorter than 1 month' for category1 , 'Shorter than 2 months' for category2 and 'Shorter than 3 months' for category 3
Can anyone show me or give tips how i can accomplish this?
Thank you in Advance
January 18th, 2011 10:38pm