You can add a table calculation "Percent of Total" by right click the measure on the Marks which appears as a label.
what is the hit ratio? Is it count of bounds divided by count of bounds and losts or divided by count of bounds + lost + quoted ?
for the latter it would be a calc as: sum (if status = 'bound' then 1 end)/sum([number of records])
Thank you Jiayi,
For the first, that really helps.
But in my case I have 3 different status, QUOTED, BOUND and LOST. By using your suggestion it takes [bound] vs. [quoted and lost], and it should take only bound against lost as quoted we do not now what is going to happen.
Do you have any solution for that?
The hit ratio I need is:
Hit ratio = (total of bound / total of (bound+losts))*100