Refer to expression in other chart

[#1]

Is it possible to refer to an expression in an other chart? I can't reuse the same expression.

[Peter_Cammaert]

BTW if you use a pivot table, you don't need two objects. A single pivot table can produce different values depending on which levels are expanded.

[#3]

You are right, the numbers that are summing the sales and volume should be the same as in chart 1 but I used random numbers so that's my mistake!

Thanks for the idea, I think that the TOTAL will work for me, do you know how I can use this in my expression when also working with variables to divide sales by volume?

[Peter_Cammaert]

I don't like copying the data from a screenshot. Can you post the output of your second chart as text (or an xlsx)?

[#5]

Thanks! I now wrote this code in the variable:

aggr( $(v_Sales) / $(v_Volume), Product Hierarchy level 1)

This code works, but not anymore when I click on a Product Hierarchy level 2. Is there anything I can do to change this?

[Peter_Cammaert]

Ok, check this one out (multiple solutions):

[avinashelite]

You want to ignore the Product Hierarchy level 2 selection in the calculation ? then add the Product Hierarchy level 2 in set analysis with {<Product Hierarchy level 2,rest_filter >}

[#8]

Yes that is what I want, where can I add this part of code to exclude level 2? It now looks like this:
aggr( $(v_Sales) / $(v_Volume), Product Hierarchy level 1)

[avinashelite]

v_Sales = you have the definition for this variable rite ? e.g sum(sales )? then try like this sum({<Product Hierarchy level 2=}Sale)