Getting the sum of a grouping

[Evan0211]

I am having trouble with a (seemingly) simple sum issue.

I have a data structure like this:

ID	Item	Cost
0001	AAA	200
0001	AAA	400
0001	AAA	300
0002	BBB	100
0002	BBB	100

When I do a =Sum(Cost), it gives me the line item number (the same as the cost), but I need to sum by the ID so 0001 has a total cost of 900, 0002 has a total cost of 200, etc.

I am sure I am overthinking something

[AshutoshBhumkar]

Hello,

If the ID and Item is same then your value should be 900 for ID 0001, Item AAA.

Sum will give segregated values only if there are different Items under one ID.

Your straight table should have below data:

Dimensions : ID, Item

Measure : Sum(Cost)

Thanls,

Ashutosh

[jlg]

If I have understood the question correctly, try:

SUM(Total <ID> Cost)