Multiple groups in same level

[george1610]

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