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 strongm 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

george1610

Programmer
Mar 27, 2025
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
 

Part and Inventory Search

Sponsor

Back
Top