Hi all,
firt of all thanks a lot in advance for any future answer.
I am struggling quite a lo with obtaining a result within a pivot table based in previous value.
For example, I have this table:
Every month I have a certain decrease of a figure.
| month |
pct |
| m01 |
1% |
| m02 |
2% |
| m03 |
3% |
| m04 |
4% |
| m05 |
5% |
| m06 |
6% |
| m07 |
7% |
| m08 |
8% |
| m09 |
9% |
| m10 |
10% |
| m11 |
11% |
| m12 |
12% |
And what I am looking for is to obtain this output:
| month |
pct |
output |
| m01 |
1% |
99,00% |
| m02 |
2% |
97,02% |
| m03 |
3% |
94,11% |
| m04 |
4% |
90,35% |
| m05 |
5% |
85,83% |
| m06 |
6% |
80,68% |
| m07 |
7% |
75,03% |
| m08 |
8% |
69,03% |
| m09 |
9% |
62,82% |
| m10 |
10% |
56,53% |
| m11 |
11% |
50,32% |
| m12 |
12% |
44,28% |
Where output is the rest of the inventory (in pct) available.
For example:
m01 value is 100% decreased by 1% --> 1* (1-0,01) --> 99.
m02 value is 99% decreased by 2% --> 0,99 * (1-0,02) --> 97,02.
m03 value is 97,02% decreased by 3% --> 0,9702* (1-0,03) --> 94,11.
And so on.
I have been playing with above, before and others, but i am not capable of finding the answer.
Thanlk a lot in advance!
Regards.
