Report with Pie Chart Problem...
I'm a relative newbie to FileMaker, and I'm having a problem that I haven't been able to wrap my head around.
I'm developing a small Purchasing database for the lab in which I work. On each purchase order, the user selects from two choices on the Use field: R & D Lab or Analytical. I'd like to create a report that shows the total YTD of each of the Use field selections, as well as a pie chart that shows the YTD total of each of the Use field selections and the current YTD amount remaining to be spent against the Annual Spending Allotment.