Add columns from a related table with filter

Hey guys
I’m trying to add some columns to this support table base on the relationship (Account) to the transactions table.

The purpose of this is to have these 3 columns on the support table :

  1. Credits for select year
  2. Credits for last year
  3. Credits for selected year filter Description “Prev Balance”
    Thanks a lot

Hi @pedroccamara

Could you please help to share the sample file along with the output what you are looking for.

Hey @MK3010
This post was not a good one. Too many conditions for success. I’ve decided to go for a merge table and problem solved.
Sorry for wasting your time.
Thanks anyway

1 Like