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?
View Complete Post