I'm new to Stack Overflow, but I'm hoping to obtain a response to one of my project questions.
City Sales Sales (LOD calculation)
Mumbai 150 50
Bangalore 90 0
Kolkata 130 -10
What would be the LOD calculation to get 0, 50, and 100 in the Sales column (LOD calculation only)?
Rows 2 and 3 are both deducted from the first row, as far as I understand. It's simple to implement with Table Calculation, but I'm stumped on the LOD component.