Column values%

[#1]

Someone knows how to display the values as% of the column?

Thanks

[oknotsen]

Change the expression to:

sum(theMeasure) / sum(TOTAL theMeasure)

... and change the display to percentage

[reddy-s]

Hi Robert,

I am assuming that you already have the values of the measure ranging from 0 and 1.(Ex: 0.46 = 46%)

In this case, in the properties panel->under the measure properties->you will find formation option turn that off and under that select Number-> in the drop down select the % format which you wanted to apply. You can do most of the number formatting using these settings.

Thanks,

Sangram

[reddy-s]

Check this Image:

[ogster1974]

ONnos solution will work and sangrams formatting will make it look good.  I've always found a nice pie chart ideal for that kind of requirement.

‌

[#6]

Very usefull, thanks!!!