Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter a table based on Total

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!! 

Need Help
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    Anonymous

     

    You can apply a visual level filter as per below:

     

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

     

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        LivioLanzo
        Solution Sage
        7 years ago

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