Calculating the percentage of all records in a layout
I have a layout page that displays the number of items in a specific category based on a field, like this:
Is there any way i can display a percentage of the total, such as 47.24% for Electronics? I have already tried using a calculation field for this, Filemaker displayed the same value for each category when I did and I could not figure out how to get the total without entering it manually into the calculation.
Im using Filemaker Pro 10 on Windows Xp. Any help would be great, thanks