Re: [libreoffice-users] How to fill in "Read filter criteria from"

Hi  again:

I hope in this way you can see better my last e-mail:

At first you have to copy the headers of your table at you side of you 

> table for example or at the end if it isn't big.
>
> Then you have to add the filter that you need and put bellow of the
> header that you want to filter.
>
> Then run the wizard : Advanced Filter (Before select the table that you
> want to filter) and in options you can select where to put the datas
> filtereds.
>
> Example:
>
>
>          Province
>             Sells
>             Costs
>           Profits
>          Alajuela
>                10
>                 2
>                 8
>        Puntarenas
>                20
>                 1
>                19
>             Limón
>                20
>                 4
>                16
>           Heredia
>                10
>                 7
>                 3
>          San José
>                20
>                 5
>                15
> Alajuela
>                10
>                 8
>                 2
> Heredia
>                40
>                 9
>                31
> Puntarenas
>                50
>                12
>                38
> Advanced Filter:(Read Filter Criteria From) 
> Province
> Sells
> Costs
> Profits
>
>
>
> > 20
>
>
>
>
>
>
> Results of Advance data Filtereds: 
> Province
> Sells
> Costs
> Profits
> Heredia
>                40
>                 9
>                31
> Puntarenas
>                50
>                12
>                38
> In this case, we filtered the column Sells to show only Province that
> have sells higher than 20




Regards,

Jorge Rodríguez



El sáb, 24-09-2016 a las 11:59 +0000, jorge escribió: 

> Hi Larry and all:
>
> At first you have to copy the headers of your table at you side of you
> table for example or at the end if it isn't big.
>
> Then you have to add the filter that you need and put bellow of the
> header that you want to filter.
>
> Then run the wizard : Advanced Filter (Before select the table that you
> want to filter) and in options you can select where to put the datas
> filtereds.
>
> Example:
>
> Table
>
> Province Sells Costs Profits
> Alajuela 10 2 8
> Puntarenas 20 1 19
> Limón 20 4 16
> Heredia 10 7 3
> San José 20 5 15
> Alajuela 10 8 2
> Heredia 40 9 31
> Puntarenas 50 12 38
>
> Advanced Filter:(Read Filter Criteria From)
>
> Province Sells Costs Profits
> > 20 
>
> Results of Advance data Filtereds: 
>
> Province Sells Costs Profits
> Heredia 40 9 31
> Puntarenas 50 12 38
>
> In this case, we filtered the column Sells to show only Province that
> have sells higher than 20
>
> I hope this help,
>
> Jorge Rodríguez
>
>
>
> El sáb, 24-09-2016 a las 16:49 -0500, Larry Evans escribió: 
> > I selected Data>Filter>Advanced Filter; however,
> > I had no idea what to do next.  I selected Help button,
> > which sent my browser to:
> >
> >  
> > https://help.libreoffice.org/index.php?title=5.1/Calc/Advanced_Filter&Language=en-US&System=UNIX&Version=5.1#bm_id3151113
> >
> > which was, again, no help.
> >
> > How do I fill out the "Advanced Filter" dialog?
> >
> > -regards,
> > Larry


-- 
Atentamente,

Jorge Rodríguez

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted