I have been following the Financial Statements tutorial.
My financial years run from April to March and all of by reporting is based on this.
My transaction table contains the FY
I am using @Melissa date table
What I 'can’t figure out is how to calculate variances between columns.
You don’t seem to be able to do it directly in Matrix, so I assume I need some type of measure as in the income statement, but can’t figure it out how to get the prior years.