Avatar of wilpitz
wilpitz
 asked on

Divide cell in crosstab with a total within the crosstab

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.

 crosstab
Crystal Reports

Avatar of undefined
Last Comment
GJParker

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
GJParker

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23