Count a column value only once

[#1]

Hi,

Can someone help me with an expression problem. I need to make a count expression to count a value only once, even if it is present in the column several times? Also i would have to do it the other way around, count line items.

Name     Orders

Gary     10

Gary     25

Eli     30

Shawn     45

Appreciate the help.. learning slowly.

[#2]

count (Distinct name)

[SunilChauhan]

see the attched file

[#4]

Sorry but i am still waiting for my Named Cal license.. Could you post the expression?

Thanks for the help.

[SunilChauhan · Accepted solution]

in dimension select name

and in expression write

count(distinct Name)