Hi All,
Hi @KP_dup_173 could you post the data instead of screenshots? Will be easier to look at/play around with.
Hi @KP_dup_173 ,
I tried my hand with some sample data created, next time it would be easier with a sample workflow :P.
The trick is how your 1st table data is structured, you cant read the data in the Column headers so I had to transpose.
From this:
To this:
then join at CCY level, then this formula:
and summarise tool:
et voila:
Probably you have to bullet proof it with some more scenarios, but it seems to have worked!
Hope that helps!
cheers!
Jonny
Thank you Luke-C - noted for next time 🙂
Thanks Jonny - This looks great. I need to have a play to build in to my flow. Appreciate your help.