cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kalif Regular Visitor
Regular Visitor

Need Help: How to set Measure in mother & child table

Dear All

 

Find below Mother Table format & have create child table as per below 

 

Mother Table

MONTHAGENCYCHG_CODEVDA AMOUNTBKG_NUMCON_NUMVDA NUM
November-18SHAL-CCUWASH9.75SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18SHAL-CCUSUR9.75SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18SHAL-CCUSOR0SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18SHAL-CCULAS0.05SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18SHAL-CCUISPS3.25SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18SHAL-CCUICOM-10SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18SHAL-CCUFRT300SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18SHAL-CCUEQP26SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18SHAL-CCUECRS150SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18SHAL-CCUDTHC117SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18SHAL-CCUDMG9.27SHLPK18001152AMFU3221483AGIN1819000129HQ

 

Child Table: 1

VDASUM = SUMMARIZE(VDA, VDA[AID_BKG_ID], VDA[AID_BKG_NUM], VDA[AID_CON_NUM],VDA[EXPECT2], "VDA AMOUNT", SUM(VDA[AID_F_AMT]))
 
Child Table: 2
 VDASUM1 = CALCULATETABLE('VDASUM', VDASUM[AID_CON_NUM] <> BLANK())
 
Filters are apply as per mother table data & Meaure will set based by Child Table 2
 
Kindly advise how to set the Measure in Mother table while reture the value from Child table 2