I am creating a forecast report in which i have to display data as follows:

[#1]

Hello Everyone,

I am creating a forecast report in which i have to display data as follows:

Header 1	Header 2	Header 3
A1	value from database	value from database
B1	value from database	value from database
C1	value from database	value from database
D1	Calculated Value	Calculated Value
E1	Calculated Value	Calculated Value
F1	Calculated Value	Calculated Value
G1	Calculated Value	Calculated Value
h1	A1's value of header3	A1's value of header 4 and so on..

where A1,B1,C1,D1,E1,F1,G1,h1 are the fields of the database in which they are present in different order.

I want to display it like above, where my A1, B1,C1 are direct values,

and D1,E1,F1,G1 are calculated value using A1,B1,C1 and one another field which is not displayed here.

and h1 is the A1's value of next header.

What should be my approach of selecting a chart and work in a desired way.

Thanks in advance.

and Regards

[Gysbert_Wassenaar]

Can you post an excel file with a table with source data and a table that shows the result?