I am creating an SSRS report where
In Dataset15, I have value Jan - 100 & Feb - 110
in Dataset16, I have value Jan - 80 & Feb - 100
Now I want to calculate same thing in a line chart using expression - Jan - 80/100
which should be 80% & Feb - 100/110 - 91%
When I am trying to find out individual monthly number 100, 110 I am getting 210 which is the summation of Both - Sum(Fields!Total.Value, "DataSet15")
.
Kindly help me out how can I get individual Numbers.
You would need to restrict your dataset to the desired month and then sum the results.
LookupSet is used to retrieve data from another dataset based on criteria.
A VBA function, SUMLookUp is need to add the results from the LookUp. This VB would go into the CODE section of the report.
You would then use the function in your expression like:
If your field is a date, then you'd need to convert both to a MMyyyy field with FORMAT: