Help on this!!

[#1]

Hi all,

can you tell me the expression to show unique data values in analysis?

Regards,

Thiru.

[kaushiknsolanki]

Hi,

     Try distinct keyword in your expression.

Regards,

Kaushik Solanki

[sushil353]

Hi,

you can use DISTINCT key word..

it is better to explain your sceanario...

HTH

Sushil

[#4 · Accepted solution]

Hi

u can use distinct in your expression

sum(DISTINCT NET_AMOUNT)

[prasad_dumbre]

Hi Thirumalai,

Can you explain some more, as not able to find out what you exactly wants. Also mention in which chart you want this. . .

[#6]

Hi Thiru,

Can you please share more details on your requirement. Though you can use distinct keyword in your expressions.

Thanks,

Angad

[#7]

Hi Thiru,

i did not understand what you need exactly but maybe you can use a .distinct when you load your data. Please send an example of what you want

g

[swuehl]

Hi,

I am not quite clear about your requirement, so a small example (like an excel file with your input data and your requested outcome or even some data lines added to your post) might help me in understanding your issue.

If you want to see the unique data values of a field, creating a list box for that field should be enough.

If you want to count e.g. only the unique order numbers, use the distinct qualifier in your aggregation function, like

=count(DISTINCT OrderNum)

Hope this helps,

Stefan

[#9]

Hi All,

I tried with count(distinct).it's working fine

Thanks..

Regards,

Thiru

[#10]

Thanks all