2 Replies Latest reply: May 15, 2014 10:01 AM by henryiriawan _ RSS

    Ability to tranpose?

    henryiriawan _

      Hello all,

       

      I want to know if Monarch can tranpose this data? The sample is shown on the 2 top rows.

       

      Thank you.

       

           

         

                      804        803            802           801        712            711          710         709          708         707            706           705           704        703          702          701          604           603          602            601      

         

        Hotel 1   236,257.18   235,908.71   209,366.05   219,524.18   232,237.36   236,577.90   267,405.75   244,586.95   275,604.72   291,680.07   294,228.26   274,049.03   223,379.46   255,522.88   196,236.08   208,412.39   182,325.45   230,253.74   155,228.79   149,698.99      

         

         

        Hotel 3   447,925.45   410,466.16   416,225.18   354,176.53   347,335.84   384,679.79   436,029.60   442,645.59   511,907.91   481,845.86   562,299.41   461,262.39   380,702.39   418,927.84   417,715.49   319,482.36   330,099.00   458,774.00   387,209.00   253,323.00      

       

      -


      Raw Data

      -


         

      12000837166   Hotel 1   90   804   236,257.18

      12000837166   Hotel 1   90   803   235,908.71

      12000837166   Hotel 1   90   802   209,366.05

      12000837166   Hotel 1   90   801   219,524.18

      12000837166   Hotel 1   90   712   232,237.36

      12000837166   Hotel 1   90   711   236,577.90

      12000837166   Hotel 1   90   710   267,405.75      

      12000837166   Hotel 1   90   709   244,586.95      

      12000837166   Hotel 1   90   708   275,604.72      

      12000837166   Hotel 1   90   707   291,680.07      

      12000837166   Hotel 1   90   706   294,228.26      

      12000837166   Hotel 1   90   705   274,049.03      

      12000837166   Hotel 1   90   704   223,379.46      

      12000837166   Hotel 1   90   703   255,522.88      

      12000837166   Hotel 1   90   702   196,236.08      

      12000837166   Hotel 1   90   701   208,412.39      

      12000837166   Hotel 1   90   604   182,325.45      

      12000837166   Hotel 1   90   603   230,253.74      

      12000837166   Hotel 1   90   602   155,228.79

      ...

      xxxxxxxxxxxxx  xxxxx x    xx   xxx    xxx,xxx.xx

       

      12016274339   Hotel 2   86   804   64,525.97      

      12016274339   Hotel 2   86   803   74,048.77      

      12016274339   Hotel 2   86   802   72,838.03      

      ...

      xxxxxxxxxxxxx  xxxxx x    xx   xxx    xxx,xxx.xx

       

       

      12017463675   Hotel 3   265   804   447,925.45      

      12017463675   Hotel 3   265   803   410,466.16      

      12017463675   Hotel 3   265   802   416,225.18      

      12017463675   Hotel 3   265   801   354,176.53      

      12017463675   Hotel 3   265   712   347,335.84      

      12017463675   Hotel 3   265   711   384,679.79      

      12017463675   Hotel 3   265   710   436,029.60      

      12017463675   Hotel 3   265   709   442,645.59      

      12017463675   Hotel 3   265   708   511,907.91

      ...

      12017463675   Hotel 3   265   601   253,323.00  

       

      /code

        • Ability to tranpose?
          joey

          If I'm understanding your question, you'd like to take the raw data and transform it into the top example?  If so, the answer is YES, and it's pretty easy.

           

          You need to trap your data and create a summary.  They Keys need to be Hotel Name and Account Number (I'm assuming that's what 804, 803, ect are).  The measure needs to be Amount. 

           

          Double click on the Account Number field in the Key area and in the Display tab select Display Values Accross instead of Down. 

           

          Let me know if this works out for you.