Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Divide cell in crosstab with a total within the crosstab

Posted on 2010-11-08
1
Medium Priority
?
1,051 Views
Last Modified: 2012-05-10
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
Comment
Question by:wilpitz
1 Comment
 
LVL 19

Accepted Solution

by:
GJParker earned 2000 total points
ID: 34091985
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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

783 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question