Hi,
I have some duplicate name and want to add figure appearing in front type 4 in final figure column.
Thanks,
Rajeev
Hi @Srawat
Your expected numbers are still not exactly correct. But I think I got a fair idea of the expected logic. Whenever a name is repeated, you want to add the below row figure to the current final figure. This can be achieved by using Multi-row formula. Multi-row formula allows you to add cells from different rows provided they follow a fixed logic pattern.
Here is a link to Multi-row formula interactive lesson: https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872
Try building it yourself. You can refer to my solution if you get stuck.
Hope this helps : )
Your numbers don't seem to match. How is E4+D7=60?
Is there any specific logic pattern this follows?
Sorry for the confusion, Please refer correct screen shot.
