Yews, I apologize, in the sample initially, I was trying to limit my question to necessity. I'm not concerned with all of the %'s, only concerned with getting a totals column to appear at the end of the report. All of my jibber jabber probably confuses the whole thing, so let me try a simpler...
Are the amounts displayed a total of Sales, Delivery, and Mgt or are these separated out?
> There are basically 5 amounts displayed per project. The first amount is total invoices for the project over the specified time period. Beneath that,each employee that shows up on the report has 4...
Yes the column heads are projects. I tried several variations of cross-tab queries, but couldn't get the data to display correctly. Here is description of where the data comes from:
6 Tables: (1)Projects = contains the title, customer info, other pertinent project data. (2)Profit Centers(PC) =...
I have a report that shows performance metrics for each employee by project. There are basically 2 key fields used: ProjectID, PCID (employee id). Here is how it looks currently:
_________________________________________________
Project Data: BOK-MOK Delivery CN Consulting
Invoice Amnt...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.