I have 3 tables on a sheet, one affected by a date selector, and 2 limited to current month and year respectively. The first table is free flowing and is affected by multiple filters whereas the others are only affected by area selected.
The free flowing calculation is
Count({<Flag_Date={'Received Date'}>}CanonicalDate)
I have the limitation calculation as follows;
Count({1<AreaName=P(AreaName),MonthYear={"$(vMonth)"},Flag_Date={'Received Date'}>}CanonicalDate)
The issue I am having is that if select an area such as the UK i.e England, Scotland, Ireland, Wales all 4 appear when no date is selected as it gives a full total of all data.
When I select this week in the free flowing table and only England appears showing the only change this week, that is fine, however in the month and year tables all the areas disappear even though there is data in them. Only England shows so I end up with a received of 30 instead of 50 for example which presents a false pretence over potential work
