Ssrs bar charts
I have bar chart it shows month names on x-axis and frequency in percentage an application is used on y-axis . It now shows each month seperately meaning aug 13% sep 4% oct 8% I would like it to show aug 13% sep 17% oct 25% meaning cumulative
addition on x- axis for the months. can you please help me.
Thanks
November 2nd, 2010 1:33pm
Hi,
If you want to show the cummulative value in the label of the barchart then use this expression in the data label of the chart
=Round(RunningValue(Fields!no.Value,Sum,"Tablix1")/Sum(Fields!no.Value, "Dataset1")*100,2)&"%"
you should get the cummulative value as you wanted.
Let me know if its working.
Regards,
Anish
"Mark this post as answer if this post helps you it might help others also"
Free Windows Admin Tool Kit Click here and download it now
November 3rd, 2010 2:21am
Hi,
As Anish posted, we could the RunningValue() function to calculate the cumulative sum.
In a simplest case by assuming the frequency of each month is already in the dataset, we can achieve this by the steps below:
1.
Bind the Month field to the category groups of the chart and bind the Frequency field as the data values.
2.
Right click the Frequence series and select Series Properties…
3.
Change the Value field to the expression like
=RunningValue(Fields!frequency.Value,Sum,nothing)
For more information about the RunningValue Function in Reporting Services, please refer to the link below:
http://msdn.microsoft.com/en-us/library/ms159136(SQL.100).aspx
Thanks,
Tony Chain
Please remember to mark the replies as answers if they help and unmark them if they provide no help
November 4th, 2010 4:09am