What I want to do, is include a new field, NAME. Here is the table I am trying to recreate:
ITEM CLASS NAME AMOUNT
One A Nick $5
One A Jerry $5
Two B Sarah $20
Three B Alex $10
Three B Carlos $6
Four A Miguel $8
My problem, however, is that when I use the below script the numbers are incorrect and are much higher than they should be. Like the above script/table, I just want to group by the ITEM & CLASS, not the NAME. Ultimately, my sum of amount, should not change at all.
Here is the script I am trying, but doesn't work...
Sum(AMOUNT) as AMOUNT
Is it possible for me to just group by the ITEM and CLASS like I did initially?