Hi
I have a query that has the following columns.
ClientName, InvoiceAmt, InvoiceDate,AmountRecieved, AmountDue, and DaysElapsed = currentdate-InvoicedDate.
I want to create a pie chart in the report that
calculates the total sum on InvoiceAmount,and then represent data in a piegraph format, that gives the percentage of InvoiceAmount whose days elapsed are 30days, 60 days, 90 Days and Over90 days.
How do i do that, Please advise.
Thanks
I have a query that has the following columns.
ClientName, InvoiceAmt, InvoiceDate,AmountRecieved, AmountDue, and DaysElapsed = currentdate-InvoicedDate.
I want to create a pie chart in the report that
calculates the total sum on InvoiceAmount,and then represent data in a piegraph format, that gives the percentage of InvoiceAmount whose days elapsed are 30days, 60 days, 90 Days and Over90 days.
How do i do that, Please advise.
Thanks