Need help with a pie chart
I'm trying to make a pie chart and need some help. I have a table of financial transaction where payments are made either by cash, cheque or bank transfer, so there is a payment method field and a payment amount field. I've made 3 calculation fields that copy the payment amount in depending on what the method is, and then I have 3 more SUM fields to total these calculation fields.
These transactions are related to another single record global data table by date so I can extract certain transaction per day or week.
I'm trying to create a pie chart showing percentages of these transactions using the summary fields based upon the relationship with the other table. I can't seem to find the right edit boxes on the chart setup box or I'm inputting the wrong information. I seem to be able to get lots of slices on the chart but not just the 3 that I need Cash, Cheque & Bank Transfer.
Any help much appreciated.