Working with Pivot Tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

M.Siler - 24 Jun 2005 20:28 GMT

I have something I can't figure out how to do because of the dynamic aspect
of the pivot table. I've put a sample document at
http://veritasinsurance.com/sample.xls

If you look at the tab "Pivot Table" and read the OBJECTIVE you'll see what
I'm trying to do.

This might not be possible without VBA code which I'm not sure I want to get
into.

Reply to this Message

Eddie O - 24 Jun 2005 23:22 GMT

It can definitely be done w/o VBA. A couple questions:
-do you have to be working with a pivot table? sometimes in cases like this
is easier to use the formulas against raw data rather than against a pivot
table.
-who get the points in the case of a tied score in # of deals/approved/funded?

I will probably need to e-mail the sheet back to you because I can't upload
it to the newsgroup, and a solution would be complicated to explain. If you
want to give me your e-mail you can e-mail me privately at ewodonnell (then
the 'at' sign) hotmail.com If you don't want to give me your e-mail I can
try to explain the solution here, after I get your answers to the questions
above.

Eddie O

> I have something I can't figure out how to do because of the dynamic aspect
> of the pivot table. I've put a sample document at
[quoted text clipped - 5 lines]
> This might not be possible without VBA code which I'm not sure I want to get
> into.

Reply to this Message

M.Siler - 27 Jun 2005 14:17 GMT

I emailed you off line... If you don't get the email please post back here
and I'll try again.

Once I have the final solution I'll post it back here for anyone else that
could use the answer.

> It can definitely be done w/o VBA. A couple questions:
> -do you have to be working with a pivot table? sometimes in cases like
[quoted text clipped - 30 lines]
>> get
>> into.

Reply to this Message