Add percentage values row based on other unique numeric row in the same table chart.

Mon, 04 Apr 2016 09:44:33 GMT

Hello everyone,

This is my problem.

I have a Table chart with only one row :

Num1 Num2 Num3

150 80 70

Num2 and Num3 are part of Num1 (Num2+Num3 = Num1)

I would like to add another row in this table where I can have a final table like this one.

Num1 Num2 Num3

value 150 80 70

perc 150 53% 47%

I saw something like that in the community long time ago, but I wasn't able to find it again.

NB. Num1 Num2 and Num 3 are expressions.

Thank you in advance.

Re: Add percentage values row based on other unique numeric row in the same table chart.

Kushal_Chawda — Mon, 04 Apr 2016 12:40:45 GMT

Create Pivot Table

Dimensions:

1) Valuelist ('Value','Perc')

2) Valuelist ('Num1','Num2','Num3')

Expression:

If(Valuelist ('Value','Perc')='Value' and Valuelist ('Num1','Num2','Num3') ='Num1',

Num1Expression,

If(Valuelist ('Value','Perc')='Value' and Valuelist ('Num1','Num2','Num3') ='Num2',

Num2Expression,

If(Valuelist ('Value','Perc')='Value' and Valuelist ('Num1','Num2','Num3') ='Num3',

Num3Expression,

f(Valuelist ('Value','Perc')='Perc' and Valuelist ('Num1','Num2','Num3') ='Num1',

Num1Expression,

If(Valuelist ('Value','Perc')='Perc' and Valuelist ('Num1','Num2','Num3') ='Num2',

num(Num1Expression/Num2Expression,'#0.00%'),

If(Valuelist ('Value','Perc')='Perc' and Valuelist ('Num1','Num2','Num3') ='Num3',

num(Num1Expression/Num3Expression,'#0.00%')))))))

Drag the Num dimension on Expression