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
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.
Retrieving data ...