Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
can you tell me the expression to show unique data values in analysis?
Regards,
Thiru.
Hi,
Try distinct keyword in your expression.
Regards,
Kaushik Solanki
Hi,
you can use DISTINCT key word..
it is better to explain your sceanario...
HTH
Sushil
Hi
u can use distinct in your expression
sum(DISTINCT NET_AMOUNT)
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. . .
Hi Thiru,
Can you please share more details on your requirement. Though you can use distinct keyword in your expressions.
Thanks,
Angad
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
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
Hi All,
I tried with count(distinct).it's working fine
Thanks..
Regards,
Thiru
Thanks all