Hello, i would like to know if there’s a simple way to perform percentage calculations across pivoted column partitioned by another pivoted column. I think the image bellow may clarify my doubt.
I would like to calculate the percentage of each of this values partitioned by the columns “Respostas do Quiz”.
Example: for the first record we have the field “Primeira” and three values (“Limite de Crédito Alto”,“Milhas Aéreas”,“Sem Anuidade”). I want to know the percentage of each one. Do the same for the column’s “Segunda” and so on.
I don’t know if i was clear about, but i hope that someone could give me some tip for solve this.
My best regards,
Rafael Cardoso