I want to calculate the percentage of "Y" (Say in Col 3) mentioned for seperate divisions (Say )1,2,3 (in col 1). Please suggest.
My requirement is to get the %age of no. of "Y", by an individual division, out of the total transaction each does.
Need to check, what percentage of each division is a Y, and then Percentage of Y in total out of the total description
|Division||Descrption (Say Anythin)||If Nomenclature Rule Followed in Description|