how to summary from distinctcount result
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23046
Printed Date: 18 May 2024 at 8:07pm
Topic: how to summary from distinctcount result
Posted By: Emir_W
Subject: how to summary from distinctcount result
Date Posted: 05 Oct 2023 at 2:19pm
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
-------------
Emir W
|
Replies:
Posted By: Emir_W
Date Posted: 05 Oct 2023 at 3:53pm
note:
Total Visit using formula distinctcount(sessionAMPM, episodeno)
-------------
Emir W
|
|