I have fields Date and Value. I want to sum value cumulatively in pivot table.
When using only one dimension (Days) on rows with below expression it works;
But when i add MonthYear dimension as column, it starts over on every month. I need to get last month's cumulative value to current month's first day value. You can check attached image. April-1 should be 99,483,228 + 4,384,563.