My Cumulative total is not changing at all. It only shows me the amount for that transaction.
I’m using Sam’s Date table and has marked the Date table as the Date Table.
I have a Customer Transactions table with a TransDate (transaction date), an amount and “DrCr” indicating whether the amount is positive or negative. The measure [Signed Amount] set the amount accordingly.
I’m trying to show the running total for a particular customer in the report.
Attached my report as well.
test cumulative.pbix (176.2 KB)