Forum Discussion

Sudhavi_84's avatar
Sudhavi_84
Helper V
5 years ago
Solved

Sum based on Child level

Hi Experts   Let me explain in simple way my problem first:-)   I have a Master Table and Fact Table.   Master Table is related One to Many with Fact Table ID. In Master Table I have Child Lev...
  • amitchandak's avatar
    5 years ago

    Sudhavi_84 , Assuming they have 1-M relation Master to fact

     

    calculate(Sum(Fact[values]), filter(Fact, Fact[Criteria] ="ABC"))

     

    Display this with child level of master