Show Percentage's in a table within the Dashboard

You can do this using subqueries, dividing each column by the total of the whole table. See an example below.

Hi Sergey,
Thanks for your repsonse.. I'm missing something
This is the SQL setup I had to get that screen from the first image
SELECT

MobilePhoneChoice,

COUNT(MobilePhoneChoice) AS Count

FROM master data

WHERE MobilePhoneChoice ='Phone Option 1' OR MobilePhoneChoice ='Phone Option 2' OR MobilePhoneChoice ='Phone Option 3' OR MobilePhoneChoice ='Phone Option 4' OR MobilePhoneChoice ='Phone Option 5' OR MobilePhoneChoice ='Phone Option 6'

GROUP BY MobilePhoneChoice
(Reason for the OR statement is because I didn't want to see blank data appearing)
I changed it to what you had and I still get an error what have I dont wrong. Sorry in advanced I'm still learning sql. This program has saved me so much time <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=77630&image=2&table=forumreplies' class='bbc_emoticon' alt=':)' />
SELECT

MobilePhoneChoice,

Count(MobilePhoneChoice),

100*Count(MobilePhoneChoice)/(Select Count(MobilePhoneChoice) from master data ) as percentage

from master data

group by MobilePhoneChoice
Kind Regards,
Richard

You miss backticks around master data, should be master data if your database is MySQL.

Thanks heaps, I knew it was something so easy <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=77642&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />