Hi All,
I have created a module with two list (Company list: A,B,C) and Fruit list (Apple, Orange, Pineapple)

Let say company A and C are tier 1 and company B is tier 2
And then i have created another module without any list dimension but just only a line item, how can i calculate the total amount of Apple selling by tier 1 company?

Thanks!!