I have attached an image of what I am working on, please refer to the image for the example.
I have a crosstab that is grouped by quarter and employee title. The 3 summary fields are $ of accounts, # of Accounts, and distinct count of employee title. i want to to create a new cell that takes the distinct count of the employees and divides it by the of $ of accounts.
Example from the attached image: The # of PB's for Q12008 is 2 and the total for the PBs' is $16,860 so I would want the new cell to display $8,430.
Also would it be possible to take the $16,860 and divide it by the total for the row ($18,120) to show 93%?
I am using version 2008.