I have field from database where percentage is already calculated.
Product Sold Total %Age sold
A 122 300 40.66
B 152 600 25.33
When I put above fields in cross tab, %Age sold field is getting summed.
Is there way that I can show data as it is from database instead of sums? Or create a %age formula in CR 11 and use in cross tab so that %age is evaluated at group level?
I know you would say use manual cross tab but we want to avoid this since cross tab is easily to create and I will have many reports where these would be used.
Thanks for your help.