Insert a column with the percentage

[#1]

Hello to all
I have a simple tabular chart with years in size, and the sum expressions for each year.
How can I enter the percentage of measures for each year?

thank you

[sunny_talwar]

Create another expression and check 'Relative' on the expression tab for the new expression you just copy pasted

[#3]

I not found the check 'Relative' on the expression tab. Where is it?

[MK9885]

Is it a Straight table/Pivot Table?

You can get a % by using '/' in between 2 expressions.

Sum(expression1)/Sum(expression2)

And in Numbers Tab check the box 'Integer' and 'Show in % Percent'

What expressions and dimensions you using in your chart?

[Anonymous · Accepted solution]

[Anonymous]

Hi,

Did you find the "Relative" option? It is in the expression tab, middle of the window, below the input for "comment".

Use the same expression as "sum expressions for each year".

Zhihong

[#7]

I'm trying with a Straight table with a Pivot Table, however, the solution could simply be put in the new column education Sum (Amount) / Sum (Total Amount).
But I would like to know where I can find thee check "Relative". 

Thank All

[MK9885]

Ok, I thought you using Pivot table hence couldn't find relative option. But for Straight table you have as shown in above Image by Marcio.