I have a query that looks like this:
So To show them grouped together I made a crosstab like this:
When I add this calcualtion:Completion Percentage: Format([Quantity]/20,"Perc
ent")I get this:
How do I do this calculation and keep it like examle 2?