gigifarrow
asked on
a Crosstab Query changes my fields when I add another calculations.
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?
DOTSInstallsCrosstabs.JPG
So To show them grouped together I made a crosstab like this:
When I add this calcualtion:Completion Percentage: Format([Quantity]/20,"Perc
How do I do this calculation and keep it like examle 2?
DOTSInstallsCrosstabs.JPG
It would be best if you could include a sample file with this.
I think the problem is that in the original query you have "Total of Quantity", which I believe is SUM([Quantity]). In your calculated column you use [Quantity]/20, which ungroups the query.
I think you need to change it to SUM([Quantity])/20 (please note the actual aggregate function needs to be used as it is in your Query). If it does not work, provide us with the actual SQL query used for Crosstab, and we will help
I think you need to change it to SUM([Quantity])/20 (please note the actual aggregate function needs to be used as it is in your Query). If it does not work, provide us with the actual SQL query used for Crosstab, and we will help
ASKER
Sorry again here is a example.
I want it to take the total and divide by the scope
MOD KIT M2 M7 M3 Total Completion Percentage
AFES 2 3 6 11 7%
HelpWithCrossTabs.accdb
I want it to take the total and divide by the scope
MOD KIT M2 M7 M3 Total Completion Percentage
AFES 2 3 6 11 7%
HelpWithCrossTabs.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for your time!! Great Job