generate amount due pie chart
i want to create a pie chart that shows the amount due from each table in my database.
basically i have 6 tables which are product tables, each have an amount column in them and a a datepaid column.
i need to show a graph which add up all the amounts in table 1 and gives a value and same for table 2 etc and displays it in a pie chart. it also needs to check that the date paid column is null as this needs to show before it is paid.
i need to of these graphs, one unique to the userid who has logged in and only shows his clients amount due and another that shows all the users in the databases totals for their clients.
can someone help me configure this please, if need be a support ticket to work on and complete this project as i am desperate to get this done.
thanks again for your support