Formula for percentage from categorical data
Hello YF and YF community,
I might just be having trouble finding what I need.
But is it possible to create a text box which shows the percentage of categorical data.
For example if I am measuring colours of cars, which is coded as (Red, Blue, Yellow)
Is there a formula that would add up all the Red cars as a percentage of the whole? Eg 27% of cars are Red.
Thank you in advance,