Filter a table based on Total

[Anonymous]

Hi all, 

I have this table 

Each row is an id number, each column is a month. The table indicates how many times each id number made a donation per month. I'd like to filter the data so that I have only the id numbers of those who make a donation per month (so at least a total of 12 donations).

Any ideas? 

Thanks in advance!! 

[LivioLanzo]

Hi  @Anonymous

Could you share your file?  thanks

[Anonymous]

Hi @LivioLanzo, yes, but I don't know how to do it. I tried with the 'share' menu, clicked on publish, but didn't succeed. How can I do that? 

sorry I'm a newbie.. 

[LivioLanzo]

You can upload it to your onedrive, dropbox etc and share a link    @Anonymous

[Anonymous]

Ha! Ok : ) 

https://drive.google.com/file/d/1fo2JxlGU7lqU3db7ivXPojoBVWA2a-I0/view?usp=sharing

[LivioLanzo · Accepted solution]

@Anonymous

You can apply a visual level filter as per below:

where Count of Donations is a mesure: Count of Donations = COUNTROWS( Feuil1 )

[Anonymous]

perfect, thank you !