Hi friends,
Please help me out to generate a generalised formula as an output for the set of data that I have attached here.
To give a context, I want to sum up values of a column based on certain conditions from different columns and also based on an unique identifier.
I have 8 persons, who has claim of the types which is mentioned as "Y" against each of the Person, based on certain conditions I generate a unique identifier, in this scenario it is P2P3P4P5 and now for this identifier I need get an output which is effectively the sum of amounts in the amount column but based on certain conditions.
So basically I want to sum the amounts based on the persons in the unique identifier and remove any duplicates while adding
In this scenario, my identifier is P2P3P4P5, so start with adding the amounts from P2 where it is "Y" and next look into P3 where it is "Y" but if the amount is already included as part of P2 neglect it and so on for P4 and P5.
This is expected output and I'm need of a formula to generalise for different scenarios, by different I mean in certain scenarios the unique identifier could be P1P2P3P6 and the same logic of summing up the amounts to be utilised.
Please help me out with this.
Thanks & regards,
Snehith
Bookmarks