View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sukh Sukh is offline
external usenet poster
 
Posts: 10
Default Complex Pivot Table

Dear All,

What I have is a Spreadsheet which is downloaded off our main database. The
function of the spreasheet is to determine how successful our employees are
at delivering training. I then create various columns which use formula's to
calculate whether the trainee has left, achieved or started within a
particular academic year. This information is presented in a table which
uses array formula's, however this information cannot be drilled down to the
individual trainees.

What I wanted to do is replicate the array table as a pivot table, but I am
having difficulties doing this. Basically I want the pivot table to treat
the columns seperately.

Hope this helps

Thanks

"Debra Dalgleish" wrote:

If you provide some information about your source data, or what
difficulty you're having in creating a single pivot table, someone may
be able to help.

Sukh wrote:
Dear All,

I have a spreadsheet with information about learners and employees. What
the sheet does is tell me when learners left and when they started, amongst
ther information. At the moment all I do is create about 15 different pivot
tables so taht management have drill down information, with each table
summarising employees and the number of leavers, employees with their number
of starts etc. However, I was hoping to create a single pivot table with all
the data in it i require ( it should look like the diagram below), but I am
at a bit of a loss as to how to do that.

Starts Leavers
Employee1 4 5
Employee2 1 6
Employee3 7 1



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html