Hello, everyone. I have an attached an image to this posting of my crosstab. If you cannot see that image, it can be accessed here:
Basically I have a simple cross tab. The "customer" is asking that I put a formula next to the summary field that basically takes the summarized amount and divides it by the total amount. In my example in the image, you see that the first person has a total of 203.25 (these are hours). 116.50 hours are billable hours, the others are overhead (OH) hours. I need to display the percentage of the hour type over the total hours, and I need to display the value to the right as you see it in my example. I started screwing around with embedded summaries to make this happened but thought I might post this and see if anybody else might tackle it some other way. It has been over a year since I have been asked to do anything like this, and I am having a memory lapse. There must be a simpler way I am not thinking of.