11 Replies Latest reply: Jun 2, 2017 7:47 AM by Petr Kyncl RSS

    How to set sum of a column as the value of a column

    Felix Hägglund

      I am making a pivottable. I have diffrent types of articles as rows. Som of the articles are specially marked in [no1] as 1.

      I have made a column that shows how many of my special products i have sold. Now - i want to make a column that shows total of sold special products - regardless of product number. In the example below, that column will show 7072 in each single cell.

       

      Is that possible? I have tried a litte bit of stacked aggregation, but with no luck so far.

      Please help me!

      2017-05-28 18-24-26.png