I have created crystal report using version XI. I have created formula field which calculates % of two database field. Which I display in detail section. I also created formula fields to display % for the group. Now I want to add chart for each group based on formula fields for group %. But I can't see these fields in available fileds in chart-data tab. Here is my example:
July August September October November December January February March April May June
Region 1 22.84 21.9 21.71 23.18 22.98 22.88 24.37 25.16 24.96 24.54 23.67 24.12
Region2 20.45 20.17 20.68 21.33 21.98 23.67 24 21.65 22.05 22.53 23.89 23.04
Region 3 12.64 14.44 14.66 16.32 15.88 11.84 12.54 13.96 14.89 13.99 12.05 12.23
Region 4 15.94 17.57 17.77 17.28 16.6 17.7 17.21 16.63 17.37 16.86 16.67 15.04
Region 5 28.84 26.83 27 26.78 26.73 25.26 25.13 23.59 23.97 24.12 23.17 20.26
Region 6 23.46 23.32 21.85 23.66 22.16 22.05 22.27 22.31 20.78 19.44 19.6 18.38
% of Sale by all Region 24.94 24.6 24.73 25.58 25.46 25.41 25.97 25.49 25.28 24.74 24.09 23.49
all the data in details section comes from formula field Like @JulyRate, @AugRate - This is the rate of particular item sold against all items sold.
% of sale by all region in group footer also come from formula field like @JulyGroupRate, @AugGroupRate
Now I want to add chart in group footer which shows % of the item sold in each month.
I can see @JulyRate in available field but can't see @JulyGroupRate! Why is that?
Can anyone please help?
Thanks.
July August September October November December January February March April May June
Region 1 22.84 21.9 21.71 23.18 22.98 22.88 24.37 25.16 24.96 24.54 23.67 24.12
Region2 20.45 20.17 20.68 21.33 21.98 23.67 24 21.65 22.05 22.53 23.89 23.04
Region 3 12.64 14.44 14.66 16.32 15.88 11.84 12.54 13.96 14.89 13.99 12.05 12.23
Region 4 15.94 17.57 17.77 17.28 16.6 17.7 17.21 16.63 17.37 16.86 16.67 15.04
Region 5 28.84 26.83 27 26.78 26.73 25.26 25.13 23.59 23.97 24.12 23.17 20.26
Region 6 23.46 23.32 21.85 23.66 22.16 22.05 22.27 22.31 20.78 19.44 19.6 18.38
% of Sale by all Region 24.94 24.6 24.73 25.58 25.46 25.41 25.97 25.49 25.28 24.74 24.09 23.49
all the data in details section comes from formula field Like @JulyRate, @AugRate - This is the rate of particular item sold against all items sold.
% of sale by all region in group footer also come from formula field like @JulyGroupRate, @AugGroupRate
Now I want to add chart in group footer which shows % of the item sold in each month.
I can see @JulyRate in available field but can't see @JulyGroupRate! Why is that?
Can anyone please help?
Thanks.