Graph the sum of five fields.

[imagen7th]

Hi I have the following values ​​and I can not bring 5 records by date of creation.

 

Record 1

 

field 1    A

field 2    B

field 3    C

field 4    X

field 5    Y

 

Record 2

 

 

field 1    A

field 2    B

field 3    C

field 4

field 5

 

 

Record 3

 

field 1    A

field 2    B

field 3    C

field 4

field 5

 

A= %

B= %

C= %

X= %

Y= %

 

For Pie Chart

 

Thanks I hope your support.

 

 

[mr_vodka]

Can you further elaborate? Can you use more specific information rather than hypothetical letters?

[LaRetta]

And if you have 5 fields which contain same type of data ( and they do because you now wish to aggregate them ) then those 5 fields should be 5 records in a child table where a single summary can provide the results you seek. Charting is based upon records. :-)

[imagen7th]

Hi.

 

This is what I need, graph 3 records

Thank.

 

[mr_vodka]

Sorry you are still not making any sense. From what I can deduce from your VERY vague example is that are LaRetta stated earlier, you need multiple records. Seem to me that you can just use one field for the various levels but it is all I can go on with your vagueness.