A
Adam Nichols
Hello,
I am wondering if anyone might have some ideas on how to do these
calculations on a large pivot table data set. I have tried doing it
through formulas in the pivot table, but because the formula varies
according to the name of the company field, it`s not straightforward.
If there is an ideal way using pivot tables, that would be good to know.
But if you think there is another more appropriate way, I`d appreciate
hearing it.
This is the original email with the details on the calculation. Thank
you for your suggestions.
Best regards,
Adam Nichols
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
I am wondering if anyone might have some ideas on how to do these
calculations on a large pivot table data set. I have tried doing it
through formulas in the pivot table, but because the formula varies
according to the name of the company field, it`s not straightforward.
If there is an ideal way using pivot tables, that would be good to know.
But if you think there is another more appropriate way, I`d appreciate
hearing it.
This is the original email with the details on the calculation. Thank
you for your suggestions.
Best regards,
Adam Nichols
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!