AnsweredAssumed Answered

Need help with a pie chart

Question asked by SimonSherwood_1 on Nov 10, 2013
Latest reply on Nov 11, 2013 by philmodjunk


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.