Use a calculated field of a table in another table

[caccio88]

Hi everyone,

I've introduced an if statement in my qvw here attached and another dimension "Codice Articolo" cause i want to know the sum of value of "Stock/1000" per month stacked per "KO" case and "OK" case.

Is my issue clear enough?

Now I want to create a new chart where the dimension is Data and the expression is the sum of value of "Stock/1000" per month stacked per "KO" case and "OK" case.

Here attached my qvw.

Thank you all

[tresesco]

Like in attached sample?

[caccio88]

tresesco What I want to create is something like that...

Where red is KO and orange is OK.

Here it is only one dimension "monthyear" but what i want is that the sum of value of KO and OK depends on what we have with the other dimension "Codice articolo" like in this straight table.

Am I a bit clearer?

[tresesco]

Like this?

[#5]

Or Like this 2 Expressions one for OK one for KO but what did tresesco works too.

Regards

Gilles