It is possible to add a column to your table, with the next formula:
What this does is filter the transactions table by all the dates that match that row’s date then it counts them
But I don’t recommend it as it would calculate the same formula for every transaction and this would slow down your doc faster as your transactions table gets bigger.
I would create a separate table with all the dates and calculate it from there.
I think im onto something with it & thanks for poiinting out about speed efficiency with large data sets. Greatly appreciate it.
If I am trying to pull in the Dates, into a Row automatically from another Table. I was planning on trying to pull it in this way.
But it seems that it just repeats all of the dates individually. In combination with what you wrote and this approeach I am trying to automatically Generate the Dates based on my data.
Thanks again Saul this will make me very excited once I understand this. I am just wanting to automatically only pull in each Date 1 time, not duplicating dates. Obviously because in some cases I have 100+'s of transactions on the same date.