Link to home
Create AccountLog in
Avatar of olongus
olongus

asked on

Aggregating max value from multiple list of items

policy        limts
1234          $20000000
1234          $20000000
1234          $20000000
1234          $20000000
4356          $34000000
4356          $34000000
4356          $34000000
4356          $34000000
2346          $90000000
2346          $90000000
2346          $90000000
total          $144000000

In the list of items above even though there are duplicate records being displayed I want to aggregate the limit value for each policy in ssrs. Help will be appreciated. Thanks.
Avatar of rshq
rshq
Flag of Iran, Islamic Republic of image

Hi

  Mybe you can use this query instead

  select  policy ,sum(limts)    from yourTable
  group by policy
Avatar of olongus
olongus

ASKER

Thanks for your comment but my goal is to perform that operation in ssrs.
ASKER CERTIFIED SOLUTION
Avatar of ValentinoV
ValentinoV
Flag of Belgium image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account