Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm a bit puzzled on a (for me as beginner) complex situation
I try to explain it with a simple table
Let's say I have a crosstable:
I load it in a crosstable, no problem:
tbl_Stocks:
CrossTable([Product], Data, 2)
LOAD Country,
Stocktype,
FROM
C:\model.xlsm
(ooxml, embedded labels, table is Totals);
I will now explain Stocktype :
T is total stock
P is production stock
now for some graphs i would like to see what amounts are in the market M, by doing M = T - P, per Product
Thanks!
Try creating a straight table chart with dimension Product and
=sum({<Stocktype={T}>} Data) - sum({<Stocktype={P}>} Data)
as expression.
This is the set analysis equivalent of
=sum(if(Stocktype='T',Data)) - sum(if(Stocktype='P',Data))
Hope this helps,
Stefan