Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What command I have to use in column Diff%?
Periode | amount | diff% |
1 | 100 | |
2 | 90 | 90,0% |
3 | 110 | 122,2% |
4 | 120 | 109,1% |
5 | 130 | 108,3% |
6 | 100 | 76,9% |
7 | 110 | 110,0% |
8 | 115 | 104,5% |
9 | 90 | 78,3% |
10 | 20 | 22,2% |
11 | 50 | 250,0% |
12 | 100 | 200,0% |
Hi @AlfredH ,
if you are using straight table or pivot chart, try to use sum(amount)/above(sum(amount)).
BR
m
Nice and simple commando.
Thanks