sums of columns into a pie chart

20 Views

Hi There, I am not the CR expert but have been asked with some CR tasks. The report development went ok so far until I came to creating a chart.

I am trying to create a PIE chart in a report and so far nothing is working.

The situation is as

follows:

I have several columns that all contain Hours.

Example:

Internal Hours ext h1 ext. h2 ext h3 ext h4

50 0 10 4 0

10 2 0 0 0

25 0 8 20 0

Each row would be associated with an employee. They may do internal work or differnt

external jobs and therefor have the hours.

So I created the sums of each of the 5 columns.

These sums I need to use in a pie chart. I created a cross tab in which I put the sums of the columns so that I have one column. I am trying to use that to create the pie chart but CR is not recognizing that cross tab so I assume what I did is not really a cross tab somehow.

Any suggestion what I can do?

Thanks,

Stephan