I have data like these in the report page:
Item_ID code_ID
xxx1 x1
xxx2 x2
xxx3 x3
xxx4 x3
xxx5 x3
xxx6 x2
I want get summary data like these:
code_ID x1 : 1 (items)
code_ID x2 : 2 (items)
code_ID x3 : 3 (items)
what should I do to get summarized data like that?
I've tried to use "CountDistinct" but the result always 6 that indicate how many of the data.
thank you.
Hi S
Im not sure what it is you want to do with the 'item'
count or sum?
I'm assuming count...
Use a table report and group by code_ID
then use items as your detail field and use
a 'Count()'
If what you want is to count the number of times a
certain code_ID appears you should use count instead of count distinct.
CountDistinct counts the number of unique entries where as count
counts the number of total entries.
I hope that I understood your question correctley
and be sure to tell me if I have not. If i was unclear
just let me know.
G
