I have a crosstab in crystal reports. the rows are grouped by worker. the columns are grouped by month. right now, there is a field for the sum of the $ each person has billed under one type of work, a sum of the $ each person has billed for another type of work, and a total of these fields.
What I have been trying to figure out, is how to add a monthly cost to the company of each employee, which changes depending on the employee, and have these grand total in the column along with the other totals, and then produce a figure which is the $ each person is generating minus the cost to the company for each person.
the problems i have had so far include:
i can't enter a constant for a person for a month without having to do a summary on it.
the billed amount has no relationship to the cost of the employee per month.
the billed amount is based on how many billed hours the employee has entered on a work order...if i try to associate a time-based amount it produces a sum.
if i put in some kind of formula based on the person's name and choose a summary such as a median to just pick out one value of multiple values for that person, then it performs the same kind of summary in the total column.
I took a look at calculated members etc. but have never used these and i got lost.
Any help would be appreciated, Experts!!