I have a dataset which includes 2 fields CaseRef, Concluded (Yes/No). I am displaying this in detail in a table. I would like to display the percentage and the formula will be,
TotalCount of Concluded where it is Yes / Total CaseRef * 100. How would I do this in reporting services?
Add a calculated field in dataset based on Yes , let it give Value 1 and 0 for No.
Add Group in table and then apply formula in group row
This should resolve
Sushil Saini Grok Innovations Uk Ltd www.grokinnovations.co.uk
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?