Aggrupate Sum for multiple Rows

[microwin88x]

Hello,

I have the following table:

Date	Type	Format	Expression
28/5/2018	Type 1	North	0,02%
28/5/2018	Type 1	South	0,88%
28/5/2018	Type 2	West	0,12%
28/5/2018	Type 2	East	3,45%
28/5/2018	Type 3	East	1,89%
28/5/2018	Type 4	West	0,02%
28/5/2018	Type 4	Noth	1,36%
28/5/2018	Type 5	South	0,25%
28/5/2018	Type 6	East	1,06%

What I need is to show the sum for each Type like this as a expression:

Date	Type	Format	Expression
28/5/2018	Type 1	North	0,90%
28/5/2018	Type 1	South	0,90%
28/5/2018	Type 2	West	3,57%
28/5/2018	Type 2	East	3,57%
28/5/2018	Type 3	East	1,89%
28/5/2018	Type 4	West	1,38%
28/5/2018	Type 4	Noth	1,38%
28/5/2018	Type 5	South	0,25%
28/5/2018	Type 6	East	1,06%

Is there any way to do that?

Thank you!!!

[sunny_talwar]

What is the expression you are using?

[sunny_talwar · Accepted solution]

It would use TOTAL <Date, Type> in the expression to get this to work