i have a column of data that stores 4 outcomes. PENDING DELIVERED CANCELLED DECLINED - I am trying to report on the number of occurences of each outcome. If i use a matrix it works perfectly giving me the counts on each outcome horizontally. Now i want to know how to add a column to the end of the matrix that basically gives me the percentage of DELIVERED outcomes to the total. I cant for the life of me figure out how to do it. The difficulty i am having is that if i filter my dataset to get the number of delivered i cant get the total number of outcomes. Please can some one give me a push in the right direction?
pending delivered cancelled declined percentage
4 6 8 10 6/total?