Forum Discussion
smmoore34
Advocate II
Advocate IIMeasure to count the # rows in each category
I have a table with a column heading Munipality and colums with the address. I want to have a measure that gives me the # addresses per muncipality. Here is a screenshot:
smmoore34 It looks like you created a new table and I'm not sure if you have to, and it looks like the relationship between the new table and existing isn't working. Also, I edited my response and added a second solution that counts the number of cities per municiplaity.
smmoore34Advocate II
Advocate IIWorked perfectly when I created it as a measure and added it to a table.
Thank-you! Happy New Year!
You're welcome, and Happy New Year to you too!