I'm sorry, ... it looks worst Jorge Rodríguez
El sáb, 24-09-2016 a las 12:20 +0000, jorge escribió: > 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 > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: [email protected] 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
