troubleshooting Question

Field coming as percentage is getting summed in cross tab

Avatar of NickHoward
NickHoward asked on
Crystal Reports
9 Comments1 Solution396 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros