1 Reply Latest reply: Jan 20, 2012 6:07 AM by Stefan Wühl RSS

    calculating formulas in crosstables

      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:

      Capture.JPG

      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!