SUM Column in text field

[#1]

Hi all,

Short question, I'm trying to calculate the total of an expression. The expression is positioned in an pivot table. How can i create a SUM of the expession in a textfield outside the pivottable?

Inside the table i use the following: =sum(Amount)*[UnitValue]

The goal is to sum the total hours in the data show in the table in a text field next to the table. look at the example below

Name	Projectnumber	Unit	Unitvalue	Amount	Total in hours
David	126456345612	Hour	1	12	12
Mark	312413534634	Day	8	4	32

How can i Sum the Total in hours column?

Kind regards,

Marco

[jagan · Accepted solution]

Hi,

Try like this

=Sum(Aggr(sum(Amount)*[UnitValue], Name, ProjectNumber, Unit))

Hope this helps you.

Regards,

Jagan.

[#3]

Thanks alot for your help!