Hi All,
Can you please help me to create below table. I have prepared a WF, however the table is not coming accordingly. Please refer the WF.
Required tables
coming as per attached WF.
Thanks,
Solved! Go to Solution.
Hi @Srawat
As the output is expected in 2 different tables.
You need to split into two Basic table then merge the tables using union tool and display the result in same spreadsheet.
Many thanks
Shanker V
Hi @Srawat
Do you want it to specifally look like your examples, if you just want the names split out tick Group By Name in the Table settings and you get this:
Hi @Srawat
Good suggestions above, but if you want your exact output you'll need to separate the data for your tables first due to the different currencies. Something like this would match your exact:
Thanks for checking. however, If I add more data in input with different currency like EUR then it's not working accordingly.
Ok @Srawat that's fair it was hard coded to your exact requirement in this instance no problem we can fix it. Roughly how many currencies are you going to have/can the same person have values for multiple currencies in your full data set?
Hey @Srawat
It feels likely that I might be forgetting an obvious check box in a reporting tool somewhere but this should work and should be dynamic. It'll just batch one name in at a time and make the table accordingly. Included USD with Sohan to test