0 Replies Latest reply: Nov 14, 2013 4:39 AM by CRISTINA TALMACIU RSS

    Creating complex crosstable

      Hi,

      I have to create a pivot table with a layout out of the standard.
      If you take a look at the attached file, you'll notice that in this table I have 12 different expressions and 7 labels (ACT Price, MP Price, PY Price MTH, PY Price AVG, YTD, YTD ACT+FCT, Total Year). So, for example: for ACT Price I need to create 3 indicators: YTD, YTD ACT+FCT, Total Year. For MP Price, PY Price MTH and PY Price AVG the same.
      How can I replicate this layout in QV?