<div>
Group level formulas only work in the group.<br />
<br />
WHere is the pivot table?<br />
<br />
mlmcc
</div>


Group level formulas only work in the group.

WHere is the pivot table?

mlmcc

<div>
I have it at the report header.
</div>


<div>
There are no groups at that point.<br />
<br />
Have you tried using a cross tab?<br />
<br />
mlmcc
</div>


There are no groups at that point.

Have you tried using a cross tab?

mlmcc

<div>
I have in a crosstab at report header level. &nbsp;Because when you view the details I get two lines for each record it distorts the totals. I have played with joins and selected disctinct records option and can not cure the two lines for one record issue. &nbsp;I have been rolling the data up to groups when needed.<br />
<br />
Sorry early on I said Pivot I meant to say Crosstab.
</div>


I have in a crosstab at report header level.  Because when you view the details I get two lines for each record it distorts the totals. I have played with joins and selected disctinct records option and can not cure the two lines for one record issue.  I have been rolling the data up to groups when needed.

Sorry early on I said Pivot I meant to say Crosstab.

<div>
Can you upload the report?<br />
<br />
mlmcc
</div>


<div>
Thanks not ideal but worked.
</div>


<div>
<div class="content wysiwyg-content">
I have a formula at the &quot;Description&quot; group level &quot;NewVaue&quot;. &nbsp;I want to put the formual in a pivot table. &nbsp;It sums all the record details which is not what I want it to do. I just want the sum for the totals for the group level the formula is in. &nbsp;&quot;Description&quot;.<br />
<br />
Please help. &nbsp;Thanks!
</div>
</div>


I have a formula at the "Description" group level "NewVaue".  I want to put the formual in a pivot table.  It sums all the record details which is not what I want it to do. I just want the sum for the totals for the group level the formula is in.  "Description".

Please help.  Thanks!

Sum of Group Formula

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.