Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you post an excel file with a table with source data and a table that shows the result?