On Tue, 2006-06-06 at 17:01 -0700, Curtis Vaughan wrote: > On 06.06.2006, at 16:41, Barrie Backhurst wrote: > > > On Tue, 2006-06-06 at 14:34 -0700, Curtis Vaughan wrote: > >> Someone sent me an Excel file with a pivot table where one of the > >> sheets uses the function GETPIVOTDATA to incorporate data from the > >> pivot table into this other sheet. > >> I was doing a search for OpenOffice's capabilities as far as this > >> function is concerned and it looks as though 2.02 should have such > >> functionality. Now, I have only tried it out so far on the Window's > >> version. Maybe only the Linux/Unix version only supports this. I > >> don't know. > >> > >> Does anyone know? > >> > >> Thanks for any input. > >> > >> Curtis Vaughan > >> > >> --------------------------------------------------------------------- > >> To unsubscribe, e-mail: [EMAIL PROTECTED] > >> For additional commands, e-mail: [EMAIL PROTECTED] > >> > > The function is available in my Linux install, but not my Windows > > install. If you do not have/want Linux installed, you could > > download and > > burn a livecd. For example Mepis, Knoppix or Ubuntu. There are many > > others, www.distrowatch.com is a good resource. > > > > Barrie > > > > ----------------------------------------------------------------- > > I'm going to try to install it, but you could probably tell me > quicker as to how many parameters does it support? > Thanks! > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] >
>From the Function Wizard GETPIVOTDATA(Target Field;Data Pilot;Field Name/Item1; Field Name/Item2;Field Name/Item3;....) where Target Field = The name of the Data Pilot field to extract Data Pilot = a reference to a cell or range in Data Pilot with the source data Field name/item(n) = Field name/value pair to filter the target data HTH Barrie --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
