I tried searching around the forum for my question/situation but have yet to see this here.
I need to add a Rolling Sum column into my dataset where they are grouped by three categories/columns;
I then need to order them by my Date field called MaxDate.
So basically it should create a rolling sum of inventory where Customer,Item, and Location are all the same and order them by their MaxDate.
I know this can be done as a measure but for my case I need it to be a calculated column.
If I need to expand on my topic please let me know! Thanks