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]

can you plz explain how u do that?

[#3]

hi,

Arul . from your question, if you want to show 3 currency in pivot table you can make a table

fact_color:

LOAD * INLINE [

amount, value

amount_1, india

amount_2, us dollar

amount_3, uero

];

then after reload in pivot table set amount as dimension and value as expression.

hope this can help you;

[jagan]

Hi,

I have created 3 expressions and formatted the numbers in Number tab.  Please check.

Regards,

Jagan.