Calculate a Sum based on a value list
This must be a pretty basic question for some here.
I have a very simple database with a few fields. What I would like to do is find a way to calculate the sum of a number field based on a value list.
To be more specific I have a value list with A,B and C an amount filed and a sum field.
I would like to have 3 fields with the sum of the amount field for every of the three members of the value list.
Thank you in advance for any help.