Sum Of Group In SSRS Report

Could you please provide the expect output ??

It's not clear from your question.

Hi,Arif

In my report I have column group A,B,C,D......Report look as

                       
                A      B      C      D
 target    10    20   30   40

Achieve   5      15   10    20

I want Sum(Achieve/target).................. but individually I mean 5/10+15/20 etc
when I write sUM(Fields!ACHIVEMENT.Value)/sUM(Fields!target.Value) it gives result of 5+15+10+20/10+20+30+40

 write it likr this
SUM(Fields!ACHIVEMENT.Value/Fields!target.Value) 

Guy Hengel [angelIII / a3]

It show same result.... as 5+15+10+20/10+20+30+40  not as (5/10)+(15/20)..

Are you using matrix?

No I am using tabular report and have column group..

Can you please post the screen shot of your report?

As per image I want sum of 0.5+0+1.33+2 in red colour textbox.

The 0 should be 1, but that apart...
Do you have an expression for that total line already? If yes use that one
You may also need to define scope
https://msdn.microsoft.com/en-us/library/dd255256.aspx

Use the same expression as you have used in text box in green back ground.

Refer the screen shot.
2016-07-22_12-46-44.png

Guy Hengel [angelIII / a3] I am using expression as , sUM(Fields!ACHIVEMENT.Value)/sUM(Fields!target.Value) I am trying to give column group scope but it gives me error...can you please provide me example.

Arif I  already use it but it gives all total not individually .......... it gives me result of 17/14 = 1.21 but I want 0.5+1+1.33+2=4.83

Hi,

I have attache the screen shot and the sample rdl as well.

Please have a look.
Report5.rdl
2016-07-22_13-13-09.png

Arif it working only for sum , if we are doing division it show wrong result

How to declare Reportvariable1 ?? and where ?? I cant find

In report property you can declare the variable.

Refer the screenshot.

Arif I am solving problem in sql so, thanks for your solution.............

can u help me to sum at group level.....I am trying as  Sum(Fields!WEIGHTAGE_ACHIVEMENT.Value,"Group_Name") but it gives error.