1 Reply Latest reply on Aug 28, 2017 8:37 AM by John Croft

    create a new calculates column

    Oliver Dilg

      Hello. i have three colums.

      customer Sales and month (01.2016/02.2016/03.2016...).

      I want to have a liste with the sales per customer.

      This is easy.

      But in this list i want this colums

       

      Customer   01.2016    02.2016   new Column 1 (02.2016-01.2016)     new colums 2 ( 01.2016 + 02.2016)

      A                  10                6                   4                                                          16

      B                    8                3                   5                                                           11

      C                   20               2                  18                                                          22

       

       

      How can i get a column what is the difference between the other 2 columns?

      How can i get a column what is the a sum of the two other colums?

       

      I hope you can understand my problem..

      many thanks

      fraggy