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+unsubscr...@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
