[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1054
  • Last Modified:

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
0
wilpitz
Asked:
wilpitz
1 Solution
 
GJParkerCommented:
One way to do this would be to use saherd variables and pass teh values around teh crosstab

To calculate the Average $ of accounts follwo these steps

1. select the $ of accounts summary field -> right mouse click -> format field -> common tab
open the tooltip text conditional formula (x->2) -> add in formula
Shared NumberVar Rev := CurrentFieldValue;

2. Select the # of accounts summary field  and add a tooltip text formula
Shared NumberVar counter := CurrentFieldValue;

3.in the crosstab expert add in the $ of accounts summary a second time at the bottom of the summary list, right mouse click -> format field -> common tab,
open the display string conditional formula (x->2) -> add in formula

Shared NumberVar Rev;
Shared NumberVar Counter;

If Counter <> 0 Then
    Cstr(Rev / Counter, 2, ',')

HTH
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now