Sorry if this is a basic question, but I just can’t seem to figure it out. I’m trying to get a count of all the records within the same table. So for e.g. say I have two columns in a table as depicted below.
I’m trying to have the “Count of all Tasks” column be dynamic so that when one more record is added, the number changes to 5 and so on. The reason is that I need to lookup this total count number into another table.
However, I’m not sure how to proceed. I can’t seem to use a Rollup or a Count type for the “Count of all Tasks” column because they need me to refer to another table. In essence, I’m trying to rollup a count of all values in the same table. I’m pretty sure this should be fairly easy and I have a blind spot here.
Any help is much appreciated.