Christmas Brain Freeze or Summing from a module when you don't have time as a dimension
I have a module (SER) with simple data for a PO, value and a year period by customer
In an invoice module (that does not have time as a dimension) i want to see the total value for that customer for the year. The invoice items has a Year based on its posting date.
This gives me the total, but i only want the total for FY21 as it is an FY21 invoice. (i.e 150)
Its probably Christmas fog, but surely this is simple and i have a mental block?