Display a bar chart depending of the selection of another one

[#1]

Hello !

I have Prodcuts which are regrouping by Category. For each products, I have a quantity for each month.

I have a first bar chart graph which display the quantity of each category by month.

When I click on Category of one month, I want to have the details of the quantity by the products of this category either in the same graph or in another one.

So I created 2 graphs, but while I haven't choose a category in the first graph, the second one has to be hidden.

Is it possible ?

Thank you

Annie

[#2 · Accepted solution]

Hi,

Go to the second chart layout tab & Show ---> in Conditional-----> not(isnull(getfieldselections(category)))

Thats it.

Regards

[#3]

Hihaaaa thank you