The table has 3 fields. Date, Marble count, and location.
The plan is to show all marble counts for each location yesterday.
But using the expression above gives all marble counts for all locations for all time periods. Until filtered on manually. We need the count to show yesterday's values only and not change when the user filters and selects data elsewhere. This will be used in a Nprinting report so having it preset for Nprinting to send out will be vital.