7 Replies Latest reply: Dec 23, 2013 11:50 AM by Gysbert Wassenaar RSS

    Expression / Formula Help!

      Hi

       

      I've loaded data into QV using cross table (in case this makes a difference) I have year as a dimension and have a poivot table showing both years side by side.

       

      The expression for the data is sum(Data) but I wanted to show a growth% for the different products as per below.  As Year is one dimension I'm stuck as how to do this?

       

      ProductsYear20122013Growth %
      Product a100       110
      Product b100        105

       

      Can anyone help?