Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
¿It is possible to have on a sheet a table with all products and on another sheet a graph that show only 1 product?
i attach a sample qwd.
thank you
so change your expression on tab 2 to
sum({<Product={x}>} KPI)
to show only Product x
but i would like to choose on the filter the different products
than change the listbos field to expression and use
=if(Product='x',Product)
Hi Pablo. I think the answer here is to use alternate states. There's a good guide here if you're not familiar with them:
You can use the sheet OnActivate and/or OnLeave events to make selections and clear them when the user goes from one sheet to another.
Easiest way is Ben's response on alternate state. Easy to make different sheets use different states.