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.
Can you spell that out in a bit more detail? I'm not sure I follow the connection between choosing values in a value list and how that affects the sum calculation.