Hi,

I have a report as below.
--------------------------------
Group1 dateadm
Group2 episodeno 1                      total visit=2 (AM, PM)
     serviceitem 1    morning (AM)
     serviceitem 2    morning (AM)
     serviceitem 1    afternoon (PM)
     serviceitem 2    afternoon (PM)

Group2 episodeno 2                      total visit=1 (AM)
     serviceitem 1    morning (AM)

Group2 episodeno 3                      total visit=1 (PM)
     serviceitem 1    morning (PM)
     serviceitem 2    morning (PM)
-----------------------------------------

I like to summarize for the total visit in group dateadm.
so, it will be like this:

Group1 dateadm       total visit=4
Group2 episodeno 1                      total visit=2 (AM, PM)
     serviceitem 1    morning (AM)
     serviceitem 2    morning (AM)
     serviceitem 1    afternoon (PM)
     serviceitem 2    afternoon (PM)

Group2 episodeno 2                      total visit=1 (AM)
     serviceitem 1    morning (AM)

Group2 episodeno 3                      total visit=1 (PM)
     serviceitem 1    afternoon (PM)
     serviceitem 2    afternoon (PM)

=======================================


How to achieve it?


thanks in advance.
emir_w      

Edited by Emir_W - 05 Oct 2023 at 2:24pm