Pl attach a workbook with fake data and your requirement.
1 of 1 people found this helpful
For dates that are spaced appropriately even when some days have no data, chart the date field as continuous. To do this, right-click and drag the date field the the Columns shelf, and then from the section that has green text choose, "Day(Date field)". The resulting pill in the columns shelf will be colored green as a reminder that the x-axis is continuous.
For the running total, first drag the desired measure to the Rows shelf. Then right-click on the pill, Quick table calculation, Running total.
Thanks so much Eric. This did the trick.