Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
If I have understood the question correctly, try:
SUM(Total <ID> Cost)