Data Required In Table

[Srawat]

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,

[ShankerV]

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

[DavidSkaife]

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:

[Srawat]

Hi @DavidSkaife 

I want like this,

[JamesCharnley]

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:

[Srawat]

Hi @JamesCharnley  

Thanks for checking. however, If I add more data in input with different currency like EUR then it's not working accordingly.

[JamesCharnley]

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? 

[Srawat]

@JamesCharnley 

It can be multiple currency with same person.

[JamesCharnley · Accepted solution]

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

[Srawat]

@JamesCharnley 

Thank you so much! Perfect solution.