Skip to Content
0
Aug 07, 2023 at 03:40 PM

Graphic Calculation View join of same table with condition

126 Views

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