1 Reply Latest reply on Feb 9, 2016 3:18 PM by John Kuo

    Getting Local Currency and USD  under one view

    jitan.chainani

      Hi Guys,

       

      Below is how the data displayed on tableau -

                                                                                                                                          Week 1      

                                                                                    Local Currency                                                                 USD

                                                                              

      Country  #Items  Date                      11/1/2012   11/2/2012     11/3/2012                               11/1/2012   11/2/2012     11/3/2012

       

      Japan     10        1/1/2012                       20                 30                40                                              25                  35             45

      Korea      50       1/1/2012                       30                 40                50                                              35                   45            55

       

      I want the USD data under Local Currency for each country.

       

      Final View

       

      Country  #Items  Date            Currency          11/1/2012   11/2/2012     11/3/2012

      Japan     10        1/1/2012             LC                        20                 30                40

                                                               USD                     25                 35                45

       

       

      Can you please suggest on how can i do this?

       

      Thanks,

      Jitan