Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
I want the whole columns to show same value. I didn't mean to make some numbers negative, as in the picture above.
Well,it should be done. I solved in script part.