<div>
MikeV<br />
<br />
&nbsp; &nbsp;The percentage needs to be the difference between two seperate summed values not the percentage of the running total of a column or row. <br />
<br />
Thanks
</div>


MikeV

   The percentage needs to be the difference between two seperate summed values not the percentage of the running total of a column or row.

Thanks

<div>
Pls post example, my first inclination is that you'll need to do a &quot;manual crosstab&quot; using variables to carry the totals.<br />
<br />
Show me a simple example of your final crosstab data.<br />
<br />
Thanks<br />
MikeV
</div>


Pls post example, my first inclination is that you'll need to do a "manual crosstab" using variables to carry the totals.

Show me a simple example of your final crosstab data.

Thanks
MikeV

<div>
<div class="content wysiwyg-content">
I am trying to create a crosstab report in crystal that will calculate the percentage between summed values that are &nbsp;grouped/totaled by month, qtr and year. If I use the weighted average feature the percentage value by month is close but not exact. The values calculated for qtr and year are completely incorrect. I have done this exact calculation in an OWC pivot table using the &quot;calculated totals&quot; feature and the result are exactly what I am looking for. Only problem with the OWC Pivot Table is that the summed values are aligned horizontally and I need them vertically. The Crystal Crosstab control gives me the presentation exactly as I need but the percentage calculations is an issue. Any suggestions. I have crystal xi with a sql2000 backend.<br />
<br />

</div>
</div>


I am trying to create a crosstab report in crystal that will calculate the percentage between summed values that are  grouped/totaled by month, qtr and year. If I use the weighted average feature the percentage value by month is close but not exact. The values calculated for qtr and year are completely incorrect. I have done this exact calculation in an OWC pivot table using the "calculated totals" feature and the result are exactly what I am looking for. Only problem with the OWC Pivot Table is that the summed values are aligned horizontally and I need them vertically. The Crystal Crosstab control gives me the presentation exactly as I need but the percentage calculations is an issue. Any suggestions. I have crystal xi with a sql2000 backend.



Crystal Crosstab percentage of summded values

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.