Hi to every one,
I have 2 tables.
- Table A with all my clients’ data and a “Modified on” column to track my daily interactions.
- Table B tracks my daily work.
So, in Table B, I have 2 columns:
- Daily date (inserted manually)
- Number of modified rows of Table A (it means interactions with my clients)
I would count automatically the number of modifications on Table A according to the date set on the first column of Table B.
I’ve tried many formulas but without reaching my goal.
[Table A].[Modified on].Filter([Table B].[Daily date] = [Table A].[Modified on]).Count()
Can someone help me, please?
Thanks a lot.