I need a event count table. I have two type of tupple from sql datasource; EventDate and EventID. All i want is counting IDs at the same date.
I can do this with using crosstab by putting Date to Column groups and ID to Detail Values with Count() expression added. But when i do this, it grows horizontally (horGrow.png).
If i put Date to Row group instead of Column, the count function doesn't work, even I type it manually(verGrow.png).
How can I get what i want?
Is there a way to make count function work well with row groups?
Or can we change row group with column group so it grow vertically?
Thanks a lot :)