Hello everyone and thanks for reading,
I have a business scenario where I use a calculation view to aggregate amounts based on GL account numbers and quarters. I pull the "BA1/HFSPD" table and select the needed fields. basically, I need to sum up amounts under the below logic:
if GL number is "A" get GL "B" which has the same Quarters as GL "A" quarters.
e.g.
row 1:
GL Qtr AMOUNT
A 1 50
B 1 60
B 2 70
since I have only Q1 for GL A then only get GL B for Q1
how should I approach this (join etc)?
I thought of join the same table twice and compare the GL's and quarters but not sure how to do so.
Any help will be much appreciated