with a pivot table, you can fix some kind of 3D table where tasks and resources are alternatively shown as rows and columns and work / cost are summarized in the inner cells.
difference from a classical table is that Excel pivot table is dynamic, i.e. you can move the row headers to columns and vice & versa
have a look at Excel online help, it is most usefull
Member for
20 years 11 monthsRE: PIVOT TABLE
There is nothing like basics, pivot tables are nothing but bata bases and their indexes. Challenge
Member for
20 years 7 monthsRE: PIVOT TABLE
Dylan, Andrew and Alexander,
Thankyou very much, They were fantastic leads to findout on Pivots.
Are there similiar sites on Access too...
Regards
Sunil
Member for
20 years 7 monthsRE: PIVOT TABLE
Here is a PivotTable paper found in the Constrcution Financial Management Association web site:
www.cfma.org/documents/PivotTables.pdf
http://www.cfma.org/pivot_dir.htm
You can also get a sample spreadsheet from here:
www.cfma.org/PIVOT.xls
Hope this helps.
Member for
20 years 11 monthsRE: PIVOT TABLE
Hi there.
Here is online tutor
http://www.contextures.com/xlPivot01.html
(See the bottom of the a.m. page for additional info)
Member for
22 years 9 monthsRE: PIVOT TABLE
msah el kheir,
with a pivot table, you can fix some kind of 3D table where tasks and resources are alternatively shown as rows and columns and work / cost are summarized in the inner cells.
difference from a classical table is that Excel pivot table is dynamic, i.e. you can move the row headers to columns and vice & versa
have a look at Excel online help, it is most usefull
good luck
Alexandre