topic Re: Getting the sum of a grouping in App Development

Getting the sum of a grouping

Evan0211 — Wed, 22 Dec 2021 16:28:40 GMT

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

Re: Getting the sum of a grouping

AshutoshBhumkar — Thu, 21 Oct 2021 16:08:54 GMT

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

Re: Getting the sum of a grouping

jlg — Thu, 21 Oct 2021 16:26:57 GMT

If I have understood the question correctly, try:

SUM(Total <ID> Cost)