Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Create a Straight Table
Dimension
[Script Number]
Expression
COUNT(Distinct [Drug Name])
Create a Straight Table
Dimension
[Script Number]
Expression
COUNT(Distinct [Drug Name])
Many thanks Manish