Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
It would use TOTAL <Date, Type> in the expression to get this to work
What is the expression you are using?
It would use TOTAL <Date, Type> in the expression to get this to work