If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
PivotChart data label as a percent.
Hi,
This is a Buying Decision questionnaire's results. I would like to show a percent of the total instead of the count on the top of each bar in the form's PivotChart. At the moment it shows the count for each category at the top of the bar. The underlying query is as follows (forgive the lengthy names). There is a main table, tblQ_0, for question number Zero and a validation table, vtblQ_0_BuyingProcess1, to convert the answer code field to text. The query and chart work fine but I don't understand how to convert my count into a percentage of the total 'population'. SELECT Count(tblQ_0.[0a Decision on Which supplier]) AS [CountOf0a Decision on Which supplier], vtblQ_0_BuyingProcess1.Q_0_AnswerCode, vtblQ_0_BuyingProcess1.AnswerText FROM tblQ_0 RIGHT JOIN vtblQ_0_BuyingProcess1 ON tblQ_0.[0a Decision on Which supplier] = vtblQ_0_BuyingProcess1.Q_0_AnswerCode GROUP BY vtblQ_0_BuyingProcess1.Q_0_AnswerCode, vtblQ_0_BuyingProcess1.AnswerText ORDER BY vtblQ_0_BuyingProcess1.Q_0_AnswerCode; Hope you can help and thanks for looking. John -- John Whyte |
Thread Tools | |
Display Modes | |
|
|