Question on crosstab

[smyeong]

Dear all,
Just wonder is it workable that I insert another column into crosstab to calculate percentage formula instead of the sum ?
My scenario is:

Category total B-100ml B-500ml B-1l Cap28mm Cap33m
bottle 100 50 50 0
cap 50 10 40


The above is created from the crosstab wizard that can give total of all column
Now, i want a new columne for calculating percentage of bottle in all total For example: 100 of 150 giving percentage, so how do i insert crosstab columne?

Below again is my crosstab design view:

Field -- Category -- Product -- Amount -- Total Of Amount: Amount
Table --1 --1 --1 --1
Total --Group By --Group By-- Sum --Sum
Crosstab --Row Heading-- Column Heading --Value --Row Heading

sort
criteria
or



Thanks in advance for your helping hands

 

[request]

rows displaying in cross tab

Hi All
I am facing problem with cross tab in crystal reports which came with .NET framework. I have placed three rows in cross tab where i am getting the data from stored procedure. For the first two rows i could able to see entire data . but in the case of third rows data is not coming completely. I have checked the format of three rows. but i didn't find any difference.
if u have an idea please do help me.
Regards
request.