sums of columns into a pie chart

[Former Member]

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

[abhilash_kumar]

Hi Stephan,

You don't need a Crosstab. Create a formula to sum the 5 columns; it might look like this:

{Hour1} + {Hour2} + {Hour3} + {Hour4} + {Hour5}

In the Pie Chart, the 'On Change' would have the Employee Name and the 'Show Values' would be this formula.

-Abhilash

[Former Member]

Hi Abhilash, thanks for responding again.

Just to be clear, what do you mean with this;

{Hour1} + {Hour2} + {Hour3} + {Hour4} + {Hour5}

Do you mean: sum H1 column + sum of H2 column +sum of H3 column +sumof h4 column + sum of H5 column?

Thax

Stephan

[abhilash_kumar]

I meant {Hour1} + {Hour2} + {Hour3} + {Hour4} + {Hour5} would be form 1 Column with values for each employe. For eg:

Employee      Internal Hours     ext h1    ext. h2     ext h3    ext h4

     ABC                 50                        0             10          4             0

     PQR                10                        2               0          0             0

     XYZ                  25                        0               8          20           0

Becomes:

Employee     Total Hours

     ABC                 64                       

     PQR                12                       

     XYZ                  53

-Abhilash                      

[Former Member]

The problem is I do not want to see the column by employee but by each hour category.

Hour type     Total Hours

     Internal             64                       

     ext1                  12                       

     ext 2                 53

I actually found an older post where you responded:

http://scn.sap.com/thread/3237584

I tried following this step by step for my solution but the chart is not populating or it is not coming back at all.

Let me know if your suggestion there would help me too. Then maybe we can see if we can troubleshoot that. Can you provide me with your email and I can sent you the report with cashed data.

stephan@ravenbay.com

[abhilash_kumar]

You may attach the report with saved data here. To attach the report change its extension from .rpt to .txt and click the 'use advanced editor' link the reply window.

-Abhilash

[Former Member]

Ok, I hope this works.

Let me know if you have any issues.

Test report1.txt.zip

Test report2.txt.zip

[former_member260594]

Hello Stephan,

You should be able to just add the employee field as the on change of field and the hour fields for the show values fields. It will tell you that the data you have selected does not fit the chart type but just click on continue and it will display.

Regards,

Graham