Hello Experts, I have a SSRS report column named sales value. And it aggregates total sales values for each store. I want to get sales value percentages of each store in a separate column named Mix%. I have tried to use: =Fields!Sales_Value.Value / SUM (Fields!Sales_Value.Value) But it always shows 1 as result. How can I solve this problem? Any idea? Regards

Perhaps you get 1 because it rounds INTEGER to 1, try converting it to DECIMAL and see how was it goingBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Thank you for your reply. But I think it is not about the data type of the column. My sales value column expression is like this. =Sum(Fields!Sale_Unit.Value) Suppose that I have three stores a,b,c. And my report layout is like: A 10 B 4 C 6 so, my mix column should be: A 50% B 20% C 30%

maybe: =Sum(Fields!Sale_Unit.Value) / Sum(Fields!Sale_Unit.Value,"DataSetName") as otherwise you will always get contextual aggregation - you are getting the 1 as the answer is 100% each time with the way you have it currently Rgds Geoff

thank you very much!