how to add values in a column with specific condition in SSRS report

See more:

ASP.NET

SSRS

heyy..

I am using the SSRS report , in that I want expression to calculate a column(bill Amount) with a condition

here is the condition
----------------------

1. if the bill number field (column wise) value are same then the same bill amount

2. if the bill number field (column wise) value are different then sum(bill amount)

eg:

itemCode   bill number   Amount    billAmount
 01           1            10        50
 02           1            40        50
 03           2            30        30

Total                      80        80

I want Bill amount result is 80 ..because the bill number are same(50), so take one bill amount and add with other bill amount(30)



I wrote an expression ,but it won't work...


=IIF(Fields!BillNumber.Value = Previous(Fields!BillNumber.Value),Fields!BillAmount.Value,Sum(Fields!BillAmount.Value))



Is any idea..???