troubleshooting Question

Crystal Report cross tab percenatage of items count in separate column

Avatar of Taras
TarasFlag for Canada asked on
Crystal Reports
4 Comments1 Solution86 ViewsLast Modified:
In Crystal Reports 2008  I have Crosstab simple layout where I present top 10 of manufacturers of 25 and totals of sold items.

Manufacturer             Number Of Items       Sold
R                  35                        
S                  22                        
C                  18                  
D                  16
N                  14
P                  12
M                  10
B                  9
A                  8
T                  6
TOTAL                  150
Total number of Items for those 10 manufactures is 150.

What I need is to add next column in my cross tab as percentage as below.
 
Manufacturer             Number Of Items       Sold       %
R                  35                        23.33
S                  22                        14.66
C                  18                        12.00
D                  16                        ...      
N                  14                        …
P                  12
M                  10
B                  9
A                  8
T                  6
TOTAL                  150
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros