operating results from 2 different charts

[thanhphongle]

Hello Community,

is it possible to operate the end results from two different charts.

excample

1st chart

Product	Cost
A	100
B	200
C	300

sum(Cost) = 600

2nd chart

Country	Taxes
Germany	19%
France	19,6%
UK	17,5%

avg(Taxes)=18,7%

Now i want to create a 3rd chart which only takes the endresults of both charts (600 and 18,7%)

-> (endresult of the 1st chart)*(endresult of the 2nd chart)=Newendresult

-> 600*18,7%=712.2

[alexandros17 · Accepted solution]

In the script you can calculate the total sum and total % of both tables, put the results in 2 variables then multiply the variables.

You can reach the same result in layout (Eg TextBox) using a sum and aggr function

[thanhphongle]

unfortunetely i cant manage it in the script. may u have a solution for me how to manipulate the script?

[thanhphongle]

and can u exactly show me how to put the results in two variables ?