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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
mlmcc. Thank you so much.
mlmcc