PIVOT TABLE

P

Philip Jonker 👤 Member for 21 years 7 months

Sun, 2005-04-17 15:08 · Permalink

There is nothing like basics, pivot tables are nothing but bata bases and their indexes. Challenge

Log in or register to post comments

S

Sunil Kumar 👤 Member for 21 years 2 months

Sun, 2005-04-17 06:12 · Permalink

Dylan, Andrew and Alexander,

Thankyou very much, They were fantastic leads to findout on Pivots.

Are there similiar sites on Access too...

Regards

Sunil

Log in or register to post comments

D

Dylan Wan, PMP EVP 👤 Member for 21 years 3 months

Sat, 2005-04-16 14:15 · Permalink

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.

Log in or register to post comments

A

Andrew Podolny 👤 Member for 21 years 6 months

Tue, 2005-04-12 03:08 · Permalink

Hi there.

Here is online tutor

http://www.contextures.com/xlPivot01.html

(See the bottom of the a.m. page for additional info)

Log in or register to post comments

A

Alexandre Faulx-Briole 👤 Member for 23 years 4 months

Mon, 2005-04-11 18:23 · Permalink

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

Log in or register to post comments

Menu

Top Posters

Menu

PIVOT TABLE

Forum Sponsor

Spider Project is most functional and powerful professional project management software.

Top Posters