I want to get the running total of by adding two measures. I have two measures "Stock def" and "Store Qty". I need running total by adding both measures. Below is the screenshot of data and my requirement (yellow highlighted).
The issue is that data is populating from two different tables and from two different measure. "Store Def" and "Store Qty" are actually two different measure. We can not use sum function on any of these measures and we can not use "EARLIER" on any measure. In your proposed solution your are taking "Store Def" and "Store Qty" as table columns and you are considering the whole data in one table but actually this grid is not populating from only one table. I can not create index on any table.
I have tried creating index using RANKX function but that can not be used with EARLIER function.