Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Tax ID | Total |
P1 | 10 |
P2 | 16 |
P1 | 20 |
P2 | 78 |
P2 | 98 |
P2 | 12 |
P2 | 25 |
P1 | 26 |
P1 | 85 |
P3 | 15 |
P4 | 23 |
P1 | 45 |
P3 | 65 |
P2 | 78 |
P4 | 25 |
P2 | 63 |
P4 | 14 |
P1 | 25 |
I have 4 Tax IDs and Total. I like to sum all the P1 to get a P1_Total, sum all the P2 to get a P2_Total and the same for P3 and P4.
How can I do this
Thanks.
create a pivot or straight table chart, add Tax ID as the dimension & sum(Total) as your expression.
I think TOTAL might be a reserved word, maybe better pick a different name for your field.