Sorry, your assumptions were correct that's why I didn't say anything. - We duplicate inside the pivot and then selected a "display as %". - The empty cell is the right one and we cheated on the format on the columns next to the % to display 0 when there is no data.

Values come from outer join and they don't cross. I used IFNULL to change NULL for zero. The user wants to show 0 % in this case. I also try to change the formar of data: #,#%;-#,#%;0,0% . It´s not working. Do you know how to force show 0%? Thank you very much.

I´ve used IFNULL function previusly to cange NULL for 0s.