I need to sum up the Amount when Column A = Column B. eg: First 2 rows, 1000 is in both columns but has different adjacent values, so i have to sum up 50 + 82 and similarly Row 4 and 5, since 1300 is in both columns need to sum up, 60 + 54. whereas row 3, is a single unique line item and that remains the same. Plz help me find the right expression.
You can change the dimension till the dimension is Unique if not you will have to aggr the expression over a unique field, if you do not have a unique field you can aggr it over A as that is a unique field.
