Hi Everyone,
I need to figure out the best logic to calculate the difference between two rows.
for example :-
| Week | 1 | 2 | 3 |
| Count of Yes | 100 | 200 | 250 |
| Count of No | 20 | 50 | 100 |
| Week | 1 | 2 | 3 |
| Drop off Yes | 100 | 50 | 0 |
| Drop off No | 30 | 50 | 0 |
The values for Count of Yes and Count of No are appeared based on filter selections.
I just need to figure out the logic for calculating Drop off Yes and Drop off No.
Logic for Drop Off Yes = Count of Yes(2) - Count of Yes(1) ie. 200-100=100
Logic for Drop Off No = count of No(2) - Count of No(2) ie. 50-20=30
Let me know if you have question.
