so..Phase I of this report is complete. The report only pulls of instances where employee Names on a given WO are different.
Phase II.
To compile data per employee Name
showing the # of Inv. that they are mentioned on - and a ton of data that will be pulled.
I was thinking using a cross tab - because- I can't regroup the report otherwise the data would be at risk...
I started with the cross tab report
Rows:
Name
Invoice Date (grouped per month)
Columns : blank...
Summarizes:
Invoice Amount
Invoice Balance
Cost
Questions:
- Is it possible to use a summary that appears in a cross tab in a formula, if yes, then how?
IP Logged
