I have a table with four distinct values. What I would like to do is create a report that takes the total of each value and returns the percentage of the total records in my table/query.
When I create it now, all of my percentages are returned as 100% instead of what I want.
Any thoughts on what is needed to correct?