How to pull extra info into Pivot table report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MLK - 18 Aug 2006 16:35 GMT

I have a pivot table report that displays ONLY the resources that left or
started with the company (grouped by manager). The execs would now like to
see percentages:

a) percentage of resources left/entered against # of employees under a manger
b) percentage of resources left/entered against the total # of employees

How would I go about doing this for a pivot table report?

Reply to this Message

Dave F - 18 Aug 2006 19:21 GMT

Calculate those percentages in the source table and then refresh the pivot
table and place those values where appropriate.

Signature

Brevity is the soul of wit.

> I have a pivot table report that displays ONLY the resources that left or
> started with the company (grouped by manager). The execs would now like to
[quoted text clipped - 4 lines]
>
> How would I go about doing this for a pivot table report?

Reply to this Message

MLK - 22 Aug 2006 01:18 GMT

Thanks. I will try that.

> Calculate those percentages in the source table and then refresh the pivot
> table and place those values where appropriate.
[quoted text clipped - 7 lines]
> >
> > How would I go about doing this for a pivot table report?

Reply to this Message