I’ve set up a simple ledger and I would like to add the totals for each category. I have two separate tables as below (not linked views of the same table.)
My [Total] column formula in the [Simple Ledger] works fine: =thisTable.filter(Date<=thisRow.Date).Amount.Sum()
However, the [Category Total] in the [Category] table is only getting the sum for the blank category. The formula I am using is: =[Simple Ledger].Filter(Category=thisRow.Name).Amount.Sum()
Any help would be appreciated.