Try creating a filter pane with a calculated dimension / field like
=Aggr( If(Sum(visitCount) >6, 'y','n') , id)
This will group your records by id field ( as I understood, id is a field that you used as dimension in your table chart, that identifies each row, maybe you can also use ClientName instead) and calculates the Sum(visitCount) per id. Just like a temporary table.
Result should be two values in your filter pane, 'y' and 'n'. Selecting one of the values should filter your id's.
Hope this helps,
and if you need to ignore certain selections that limit the ids, you need to use set analysis in the Sum(), for example to ignore all selections:
Hi solomon.musayev, in this case if u mention that the fiel visitcount save number 1 for each visit i think the correct form for u solution would be this.
1. Do the load of Your table, for the fuield countvisit must be a count(), in order to count all the visits for each Clientname, for this the group by, and in the superior part of the table a precedent load giving it the codition for the flag.
if(VISITCOUNTER>6,'Y', 'N') AS FLAG;
" Start Year",
COUNT(visitcount) as VISITCOUNTER
GROUP BY id, ClientName, " Start Year", "Start Month";
I could undertand this, if I am wrong please let me know.