Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple groups in same level

Status
Not open for further replies.

george1610

Programmer
Joined
Mar 27, 2025
Messages
1
Hi all,

I have the dataset like:

SAMPLE_TYPE TESTS BOTTLES
--------------- ------- ----------
A T1 B1
A T2 B1
A T2 B1
B T1 B2
B T2 B3


How to group the above dataset into two different groups in CR?
TESTS fields need count of such test and BOTTLES field need distinct the value. Thanks.

SAMPLE_TYPE: A
TESTS COUNT
------ --------
T1 1
T2 2
BOTTLES
---------
B1

SAMPLE_TYPE: B
TESTS COUNT
------ --------
T1 1
T2 1
BOTTLES
---------
B2
B3
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top