Percentage sign not showing for columns in report book

I think I found the solution to this. Under Rows, there is a section called Column Overrides, all I needed to do was to add the columns that I want to show percentage sign in column range  and put the cell format I want to have for those columns. below is my example. 

Another option, if you do not want to use a column range override on specific rows, is to use a default conditional formatting option based upon your column naming convention.

For example, if all your column names contain "_%" or "%" or "PCT" in the cube view column name, you can key in on that to add your number formatting standard.

It would be something like this:

If (ColName Contains '_%') Then
Add your formatting here
End If

This way if you name your columns consistently you do not have to update the override for non-contiguous or newly added columns in the future.