Forum Discussion

Jeff2Jets's avatar
Jeff2Jets
Helper III
1 year ago
Solved

Create a new column

I have two tables. For this question, I will call them 'States' and 'Counties'. The 'States' table has many columns about each State; State Capital, State Flag, State Bird, State Flower, etc. Th...
Need Help
  • FreemanZ's avatar
    FreemanZ
    1 year ago

    hi Jeff2Jets ,

     

    ensure relate both tables, then write a calculated column in states table like:

    Count =

    COUNTROWS(RELATEDTABLE(Counties))

Jeff2Jets's avatar
Jeff2Jets
Helper III
1 year ago

Thanks! That was exactly what I needed.