Calculate a column help
Posted: Thu Apr 26, 2018 11:00 pm
I want to populate each row of this table (NumDays) with the count of rows from this table that have the value of KEY1. I have this working by extrapolating the data from an additional table we added but I'd like to not have to do that. How do I do this?
Re: Calculate a column help
Posted: Sun Jul 01, 2018 6:06 pm
Assuming your data table is called "NumDays", which is what I understand from your description, and that you want the frequency (count) of each value appearing in the column labelled "KEY1", which is again what I understand from your description, you can get this count in a calculated column, by writing