how to add percentage total below the total entry..

[edgarbenilde]

can somebody help me how can i add percentage per column of the total and result total also as 100%


see the image attached..

Month       Playing               Reading                      Total          Percentage
1               1                         2                             3                17.65% 
2               1                         3                             4                 23.53%
5               2                         2                             4                23.53%
4               1                         2                             3                17.65%
8               2                         1                             3                17.65%
Total          7                         10                           17               100%
% total    (41.18%)              (59.82%)                  (100%) 

those bold line i want to add it... please help me how? please see the status of my report in the image..

[jggtz]

Try with SubReports
Could be :
the main report calculate the total,
detail section suppressed,
insert a subreport (your actual report) at report footer section using the total from the main report thru linked variables

[edgarbenilde]

how can i make it percentage format.. and how can i make the result the as what i wanted to do in post # 1?

[edgarbenilde]

how can i make it with percent sign... i have already the field that count the activity per month but i only get the value not the percentage equivalent..

mymonth         Playing        Reading       Total       Percent      
   1                    1                  3               4           57.41%          
   2                    2                  1               3           42.85% 
  Total               3                   4               7            100% 
Percent            42.85%           57.41%       100%

[edgarbenilde]

i've tried subreport but i only get the same value as the images i've attached in the post # 1.. please help me how can i make it done here...

any help please?

[brucevde]

Which version of Crystal are you using? Is this a Cross-Tab report?

If you are using Crystal 9 or above you should be able to add the Percentages directly to the Cross Tab report.

[edgarbenilde]

im using version 9