Sum data

[Anonymous]

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.

[#2]

create a pivot or straight table chart, add Tax ID as the dimension & sum(Total) as your expression.

[#3]

I think TOTAL might be a reserved word, maybe better pick a different name for your field.