how to add percentage total below the total entry..
can somebody help me how can i add percentage per column of the total and result total also as 100%
see the image attached..
Code:
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..
Re: how to add percentage total below the total entry..
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
Re: how to add percentage total below the total entry..
how can i make it percentage format.. and how can i make the result the as what i wanted to do in post # 1?
Re: how to add percentage total below the total entry..
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..
vb Code:
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%
Re: how to add percentage total below the total entry..
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?
Re: how to add percentage total below the total entry..
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.
Re: how to add percentage total below the total entry..