0 Replies Latest reply on Feb 6, 2016 12:13 PM by priyankjayna

    sum of amount from various fields and make a monthly graph

    priyankjayna

      I have many clients making payments at different times for different items(have data for last five years).i would like to have a graph depicting total monthly income. with a new graph for every year

       

      currently have made a table with client information and a related table (related by name) with the payment date and payment amount.

       

      client::name

      client::age

      client::sex

      client::ip amount

      client::ip recvd on

      client::ip1 amount

      client::ip1 recvd on

      client::ip2 amount

      client::ip2 recvd on

      client::ip3 amount

      client::ip3 recvd on

       

      payment::name

      payment::payment

      payment::payment recvd on

      payment::balance

      payment::balance recvd on

       

      i want to add ip amount, ip1 amount, ip2 amount, ip3 amount, payment, balance

      and then graph them monthly and yearly (depending on recd on)

       

      picture of current layout is attached