How to display table cell as percentage?

[spagad6263]

Hi,

I would like display a cell value as percentage, but couldn't see an option. At the moment, I have to create a measure, and set the format for this measure. However this is very inconvenient. Any suggestions? Thanks 

[Accelins · Accepted solution]

you can show % of grand total in a matrix visual 

[spagad6263]

Thanks for the help!

[spagad6263]

Hi, if I chanaged to Sum, I can only see below option, which is not really what I need. I am a bit surprise as I though I should be able to format the cell this way. Any other thoughts? Thanks so much for the info

[spagad6263]

Thanks for the quick response. The value is not for the Grand Total. It's for each individual row, and I can't see the option like your screen shot - see below. Am I missing something? Thanks

[Accelins · Accepted solution]

If you select the Sum part first that option should be available, and if you have it as a matrix you can do it as a % of the Column or row total! 

[Accelins · Accepted solution]

you can show % of grand total in a matrix visual