How to show the sum of hour types in each column on an Hours report?

[CelSal01]

I created an hours report that breaks down hours by hour type in separate columns. Is it possible to sum each column? I tried the following but it gives me a sum of all the hours, not just the "X40" hours I'm filtering for.

aggregator.displayformat=doubleAsInt
aggregator.function=SUM
aggregator.namekey=hours
aggregator.valuefield=hours
aggregator.valueformat=doubleAsInt
displayname=Test SUM
linkedname=direct
namekey=hours
querysort=hours
valueexpression=IF({hourType}.{name}="X40",{hours},0)
valuefield=hours
valueformat=

[Sven-iX]

Have you tried adding the calculation to the aggregator:

aggregator.displayformat=doubleAsInt
aggregator.function=SUM
aggregator.namekey=hours
aggregator.valueexpression=IF({hourType}.{name}="X40",{hours},0)
aggregator.valueformat=doubleAsInt
displayname=Test SUM
linkedname=direct
namekey=hours
querysort=hours
valueexpression=IF({hourType}.{name}="X40",{hours},0)
valuefield=hours
valueformat=

[CelSal01]

Thanks, @Sven-iX. It worked, but only if grouped by hour type. Is there a way to do it so it shows the sum per column at the owner grouping and not have to group by hour type to show the sum like in the attached screenshot?  

[Sven-iX · Accepted solution]

works fine for me across 3 groupings

example column

valueexpression=if({hourType}.{name}="General Overhead", {hours}, 0)
valueformat=double
aggregator.valueexpression=if({hourType}.{name}="General Overhead", {hours}, 0)
aggregator.function=SUM
aggregator.valueformat=doubleAsDouble
aggregator.displayformat=double
displayname=General Overhead
namekey=hour.plural
width=65
querysort=hours
listsort=doubleAsDouble(hours)

[CelSal01]

Ahh this is perfect and now works great! THANK YOU!