1 Reply Latest reply: Oct 31, 2013 6:46 AM by Gysbert Wassenaar RSS

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

      Hello Everyone,

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

      Header 1Header 2Header 3
      A1value from databasevalue from database
      B1value from databasevalue from database
      C1value from databasevalue from database
      D1Calculated ValueCalculated Value
      E1Calculated ValueCalculated Value
      F1Calculated ValueCalculated Value
      G1Calculated ValueCalculated Value
      h1A1's value of header3A1'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