We help IT Professionals succeed at work.

Crystal Report cross tab percenatage of items count in separate column

Taras
Taras asked
on
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
Comment
Watch Question

Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Have you tried putting the sold object into a second time and using a % as the summary?

mlmcc

Author

Commented:
Where to put sold object second time??
I do not want two values in one column.
Yes i tried Your suggestion and I got rezultat in the same column  below number of sold. I need  % in separate column.
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Like this one.

As I said
Insert the Sales Summary twice
First set as Sum
Second Set to display a % of total

On the Customize Tab of the Cross Tab Expert
Set to summarize horizontally

mlmcc
Cross-Tab-Percent.rpt
Cross-Tab-Percent.xls

Author

Commented:
mlmcc. Thank you so much.