Hi,
I have a module with 3 different list formatted LIs and an amount line item. I want to sum the amount in the module basis these line items such that any list item that has these 3 properties similar should show the same value. I know this could be done using sum and lookup but wanted to see if there is a better way to do this. Here is a mockup
Dimension | Property 1 | Property 2 | Property 3 | Amount | Sum |
a | x | y | z | 1 | 3 |
b | | | | 1 | |
c | x | y | z | 1 | 3 |
d | | | | 1 | |
e | | | | 1 | |
f | x | y | z | 1 | 3 |
g | | | | 1 | |
h | | | | 1 | |
i | | | | 1 | |