### Title

Need help with a pie chart

### Post

Hi

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.

Simon.

It might be simpler to base your layout on Transactions, A single summary field can then return the subtotals for each wedge.

But working with Reports as your layout context:

List ( SumField1 ; SumField2 ; SumField3 )

can be the calculation you use for your y-series (wedges).

List ( "Field1Wedgelabel" ; "Field2WedgeLabel" ; "Field3WedgeLabel" )

Can be the x-series (wedge labels).

In your data source settings, you'll need to specify that you are using delimited data.