Tableau - What would the LOD calculation be

Question

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.

Answer 1

Based on your requirements, I don't feel a LOD expression would be appropriate. You said that you can already achieve your findings using table calculations, which is the correct way for this situation.

When you need to execute some aggregation of your data that is at a different granularity than the specified dimensions, LOD expressions are employed.

I hope this information is useful.