3 Replies Latest reply: Jun 17, 2014 5:49 AM by Ashfaq Mohammed

# Pie chart and value from table

Hello all,

Is there a way to use the values from table in pie chart?

Table:

column1 column2 column3 column4

exp1          exp2     exp3     exp1+exp2+exp3

I want to put the values of column4 in pie chart.

Is it posssible?

• ###### Re: Pie chart and value from table

Nemanja

a pie chart will display 1 expression according to dimension

More than 1 (or 2) expression won't be easily readable.

You have to store your total at the same level of other dimension

best regards

Chris

• ###### Re: Pie chart and value from table

No, that's not possible. You'll have to reuse the expressions from the chart and create one expression from them for the pie chart. What you can do is put the original expressions in variables and use the variables in the table and the pie chart. That way you'll have to maintain them in only one place.

vVar1: sum(X)

vVar2: sum(Y)

vVar3: sum(Z)

exp1: \$(vVar1)

exp2: \$(vVar2)

exp3: \$(vVar3)

exp4: \$(vVar1) + \$(vVar2) + \$(vVar3)

• ###### Re: Pie chart and value from table

Hi Yo can write your expression as

exp1+exp2+exp3

You cannot use it from another chart

Regards

ASHFAQ