Sum column with values to get same value for entire column

[Anonymous]

Hi everyone,

Looking to get "Total Man Hour Cost".

it uses the columns "Project Name, "Year", "Element Categoru", "Organization", and "Cost"

There are more columns in the data set, so that's the reason why I list the needed columns to calculate "Total Man Hour Cost"

Any advice on this?

Project Name	Year	Element Category	Organisation	Month	Cost	Total Man Hour Cost
AAA	2023	Man Hour Cost	COO	Jan	14	212
AAA	2023	Man Hour Cost	COO	Feb	14	212
AAA	2023	Man Hour Cost	COO	Mar	14	212
AAA	2023	Man Hour Cost	COO	Apr	14	212
AAA	2023	Man Hour Cost	COO	May	14	212
AAA	2023	Man Hour Cost	COO	Jun	14	212
AAA	2023	Man Hour Cost	COO	Jul	14	212
AAA	2023	Man Hour Cost	COO	Aug	14	212
AAA	2023	Man Hour Cost	COO	Sep	14	212
AAA	2023	Man Hour Cost	COO	Oct	14	212
AAA	2023	Man Hour Cost	COO	Nov	14	212
AAA	2023	Man Hour Cost	COO	Dec	14	212
AAA	2023	Man Hour Cost	COO	Oct	16,8	212
AAA	2023	Man Hour Cost	COO	Nov	16,8	212
AAA	2023	Man Hour Cost	COO	Dec	16,8	212
BBB	2023	Man Hour Cost	COO	Jan	1	116
BBB	2023	Man Hour Cost	COO	Feb	1	116
BBB	2023	Man Hour Cost	COO	Mar	1	116
BBB	2023	Man Hour Cost	COO	Apr	1	116
BBB	2023	Man Hour Cost	COO	May	1	116
BBB	2023	Man Hour Cost	COO	Jun	1	116
BBB	2023	Man Hour Cost	COO	Jul	1	116
BBB	2023	Man Hour Cost	COO	Aug	1	116
BBB	2023	Man Hour Cost	COO	Sep	1	116
BBB	2023	Man Hour Cost	COO	Oct	1	116
BBB	2023	Man Hour Cost	COO	Jan	9	116
BBB	2023	Man Hour Cost	COO	Feb	9	116
BBB	2023	Man Hour Cost	COO	Mar	9	116
BBB	2023	Man Hour Cost	COO	Apr	9	116
BBB	2023	Man Hour Cost	COO	May	9	116
BBB	2023	Man Hour Cost	COO	Jun	9	116
BBB	2023	Man Hour Cost	COO	Jul	9	116
BBB	2023	Man Hour Cost	COO	Aug	9	116
BBB	2023	Man Hour Cost	COO	Sep	9	116
BBB	2023	Man Hour Cost	COO	Oct	9	116
BBB	2023	Man Hour Cost	COO	Nov	9	116
BBB	2023	Man Hour Cost	COO	Dec	9	116

[amitchandak]

@Anonymous , You can have a new calculated column like

Sumx(filter(Table, [Project Name] = earlier([Project Name]) && [Year] =earlier([Year]) && [Element Category] = earlier([Element Category) && [Organisation] =earlier([Organisation)), [Cost])

[Anonymous]

@amitchandak  Thanks for your input! It works very well.

One thing I forgot to mention is the column "Organization" has multiple values and I only want "COO".
Is there a way to filter on "Organization"? 

[Anonymous · Accepted solution]

Hi @Anonymous 

You just need to modify the formula a bit like below:

Sumx(filter(Table, [Project Name] = earlier([Project Name]) && [Year] =earlier([Year]) && [Element Category] = earlier([Element Category]) && [Organisation] ="COO"), [Cost])

Best Regards,
Jing