multi values in single column

[arulsettu]

Hi

     i am having currency in three country format

     ex:

          amount_1 - is india

          amount_2 -is us dollar

          amount_3 -is euro

now i need to show like this in pivot or straight table

Account_num   amount

1100               20000 rs

                      333 $

                      259 Euro

1101               30000 rs

                      433 $

                      359 Euro

any one plz suggest some advice how to achieve this

thanks

[arulsettu]

any help guys?

[anbu1984]

Can you post sample input?

In input, do you have three rows for each account?

[arulsettu]

hi Anbu,

               i am having amount in three different fields for each account i am having amount in three formats

          amount_1 - is india

          amount_2 -is us dollar

          amount_3 -is euro

[jagan]

Hi,

Attach some sample data which you have so that it would be easier to provide the solution.

Regards,

Jagan.

[arulsettu]

here is the sample data

[arulsettu]

Hi Jagan,

               check above sample data

thanks

[#8]

Hi Arul,

have a look at using crosstable() to convert those three fields into a single field, you'll then have three rows one for each of the currencies

see attached

Hope that helps

Joe

[jagan · Accepted solution]

Hi,

Please find attached file for solution.

Regards,

Jagan.

[anbu1984]

Check this app