1 Reply Latest reply on Jan 19, 2015 11:16 AM by KK Molugu

# How to sum the amount of unique account?

I have a table like this:

ID                   Amount                Marketing

1                     100                       10

1                     100                        20

1                     100                        5

1                     100                        1

2                      200                       5

2                      200                       9

2                      200                        7

2                      200                        5

2                      200                       10

2                      200                        21

3                      300                        9

3                      300                        8

3                      300                        9

The relationship of ID to Amount is 1 to 1. But after jointing two tables, one ID has four amount.

How can I sum the amount for unique ID? The result should be 100+200+300=600

Thanks!

• ###### 1. Re: How to sum the amount of unique account?

Carine:

Based on what you are trying to achieve, you can use the min(amount) to show as below and show column grand totals and

OR

use table calculations just to get the end value 600

See attached and hope that helps

..kk

1 of 1 people found this helpful