Hi all,
I'm having trouble using the count function to display a count of records throughout the report where that record shows up (after report is sectioned).
Example:
ID Business
12345 McDonald's
12345 Burger King
12345 Subway
The count of 'ID' is 3. My report is sectioned by business, so ID=12345 will show up in each of these business' sections. I need a column where a count of 3 shows up every time the record appears. This let's me know the record appears 3 times in the report (no matter which business I'm looking at).
Any suggestions?
Thanks,
JP