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