asked on Crystal Report cross tab percenatage of items count in separate column
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
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
Crystal Reports
Last Comment
Taras
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
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.
ASKER
mlmcc. Thank you so much.
mlmcc