Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to Sum on Data per ID that are already not in display?

I have a crystal report whose data structure s as follows;

to numberStop NUMBERPOKGSSOHeader
1000001PO110SO1
1000002PO220SO2
1000002PO330SO3
1000002PO440SO4
My Report Design is as follows:

Group on TO NUMBer

--------------------------------

Data

Group on Stop ID

--------------------------------

group on stop number

---------------------------------

Data

--------------------------------

Details- Suppressed as I need only one record to be shown per Stop

-------------------------------

The KGS Field is in the Group StopNumber. I cannot move it to the details section as it will violate my requirement.

Currently it shows

Stop 1

PO1 SO1 10 KGS

STOP2

PO2 SO2 20KGS

I want it to show as follows:

Stop 1

PO1 SO1 10 KGS

STOP2

PO2 SO2 90KGS

90 kgs is the sm of 20+30+40 kgs

Please help .

Thanks in advance

Former Member
replied

Hi Reshma,

Go to the Insert Summary Option > choose the KGS field as the Field to Summarize, choose Sum as the Summary Operation and place the summary on GRoup Header #2 instead of the default Report Footer (Grand Total).

-Abhilash

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question