Counting no of items per prescription

[Anonymous]

I have the following data:

I need to be able to count the number of items per prescription.  Each prescription has a unique identifier 'Script Number'.  For example Script Number 181848 has 6 different items and  Script Number 18149 has 2 items.  What expression can i use to achieve this?

Regards.

[MK_QSL · Accepted solution]

Create a Straight Table

Dimension

[Script Number]

Expression

COUNT(Distinct [Drug Name])

[Anonymous]

Many thanks Manish